DAX– tag –
-
[Vol. 6] How to Calculate YoY and Target Achievement in Power BI: DAX Measures
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol.5, we created four basic KPI measures: Operating Margin, Utilization Rate, Inventory Turnover, and Defect Rate. In this article, we will cr... -
[Vol. 5] How to Create Power BI KPI Measures: DAX SUM, AVERAGE and DIVIDE
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 4, we created a Calendar table and connected the four fact tables to both the Calendar master table and the line master table to build the... -
[Vol. 4] How to Create a Calendar Table in Power BI: DAX & Relationships
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 3, we imported five CSV files using Power Query and prepared the column names and data types. In this article, we will build the foundatio... -
[Vol.3] How to Import CSV Files into Power BI: Power Query Basics
Financial Analytics & Automation / Power BI KPI Dashboard Creation Series Introduction In Vol. 2, we covered how to install Power BI Desktop and explored its main interface. You should now have a basic understanding of key areas such...
1