Forum Discussion
Breaking down one-stop data dump
Hello: I am relatively new to modeling in Power BI. I am working with a dataset that is essentially a one-stop dump for everything. Refer below: Qtr Fiscal Year Country Category Sub...
isam2003 , One should ideally create Dimension join it back to fact
example - Distinct(Table[Country])
Qtr year table with Qtr year key or Create date from these two join with date table
Similar example
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda