The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear all,
I have an issue with a Power BI File using big data sources. After a quick analysis, I realised that my DAX queries are the reason behind the slowness of my file, so I'm trying to convert most of my DAX queries to the Power query editor.
I have an issue with the calcultion of Standard deviation for a DATA column that I have to calculate by Grouped data and I can't use the "Group by" function, I need to have an additional calumn containing the standard deaviation .
Here below the DAX formula that was percectly working for me and that I want to convert to Power query :
TRT_STD =
CALCULATE ( STDEV.S ( ASSESSMENT [DATA] ), ALLEXCEPT ( Table, Table[group.data] ) )
Thank you in advance for your help !
Although sometimes it is necessary to pre-calculate stuff to improve performance, I would stick with DAX and optimize your model if necessary. This will make your calculations responsive to slicers and overall provide more flexibility in reporting/analysis. Is your model a star schema? How many values in your visual?
Pat
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
106 | |
103 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |