If you are struggling to write a complicated DAX formula then the answer may be to step back and do a little Power Query Magic to help yourself
00:18 The Scenario
03:32 The Power Query Helpers
09:09 Load to the Data Model
10:10 Writing the simplified DAX in Excel
13:51 Showing the equivalent in Power BI
15:50 Link to Calendar Video
daxpatterns.com
www.daxpattern...
Access Analytic Calendar Table and other useful stuff
accessanalytic...
Download the file I used
aasolutions.sh...
Connect with me
wyn.bio.link/
accessanalytic...
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Негізгі бет How to SIMPLIFY DAX using Power Query
No video
Пікірлер: 68