Tag: Power BI Modeling

Data Model For Power BI Retail Sites Dashboards

By Sam McKay, CFA on December 19, 2020July 14, 2021

Data Model For Power BI Retail Site Dashboards

In this tutorial, you’ll learn about developing a data model for Power BI Retail Sites Dashboards. The methods discussed will help you harvest valuable insights easily from your report. From start to finish, you’ll see how amazing DAX formulas are in calculating and filtering results for you to harvest and gather. Arranging The Data Tables

Posted in: Data Modeling in Power BI, Data Tables, dataflows in power bi, Fact Tables, Power BI Data Model, Power BI Lookup Table, Power BI Modeling, Power BI relationships, Retail Dashboard

Data Modeling Data Visualization DAX Enterprise DNA Power BI

Filtering Data By Custom Fiscal Years And Quarters Using Calculated Columns In Power BI

By Sam McKay, CFA on March 25, 2020May 11, 2022

There can be times when your date tables won’t have the custom fiscal years and quarters that you require as filters for your analysis. In this tutorial, we are going to discuss how you can filter your data by financial or fiscal years and quarters using calculated columns in Power BI. You may watch the

Posted in: Calculated Columns, Date Table, Financial Analytics, financial years Power BI, Fiscal Year Months Power BI, Fiscal Year Quarter Power BI, Power BI Modeling, Power BI Slicers