Simpler DAX ? = Power Query
Wyn Hopkins
Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views
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.
The liberal use of helper "flag" columns in Power Query can very often simplify the DAX required.
I hope you find this useful.
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
Reach out to us at [email protected] if you are interested in us assisting you.
Wyn
Author of "Power BI for the Excel Analyst "
Microsoft MVP
Business Intelligence, Data Analytics, Reporting & Insights | KPI Metrics, Dashboards & Storytelling | IBCS Certified | Performance Management | Operational Excellence| CX, Training, L&D
1 年thx for sharing this Wyn Hopkins this is in line w/ Roche's Maxim do your transformations "as far upstream as possible, and downstream as necessary" Go Data! Go PQ, PBI :)
Technical Architect, ValueLabs | Power BI| Tableau | SQL | Data Modeling | Version Control | Prompt Engineering
1 年Great Post Wyn Hopkins I have always emphasised this part of creating a great Data model with all your necessary columns and the amount of difference this makes while writing DAX is humongous and makes your life really easy