Forum Discussion
Helper VPivot Table in Excel to PowerBI
Super UserJoining on not unique keys is of concernUse composite keys. If you can't, at the very minumum use single direction many-to-many relationships.
I do left joins to the Fact table and some inner join. Please advise.Inner joins require clean data. Yours has lots of gaps. If you do a left join you need to make sure that the left column does not have nulls.
You have lots of dimensions in your data model that seem to overlap in their meaning. As you mentioned, whenever you have a 1-to-1 bidirectional relationship that is an indication that the tables should be merged. I wouldn't necessarily call that denormalization, though.
the joins take a lot of memory
You don't have to do the joins / merges in Power Query. Let the data model do the work for you. Try to have join columns with low cardinality.
Helper VI have brought in the Pivot table as an example of what the PowerBI report should look like, see:https://drive.google.com/file/d/1_XyrEdRUsQImyuDhapkA5fqcpXRGUjRV/view?usp=sharing .
Cash Flow tab in this file, https://docs.google.com/spreadsheets/d/1mN6dGl4NY9N8yrXDpmx_CTJnZbxL61Zi/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true represents the final look with calculations as seen in my PBIX file. Source Data in the same file is my data in SQL DB. Please advise what will be the best way to get my data model/report aligned so that I can do the formulas in PowerBI using DAX as seen in the Cash Flow tab, column K.