Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello together!
I have a very large table that shows me when which process was started and ended, per order:
Article | Order Nr | Process Step | Start | End |
Bike | 1 | 01 | 01.01.2022 | 01.01.2022 |
Bike | 1 | 02 | 01.01.2022 | 05.01.2022 |
Bike | 1 | 03 | 10.01.2022 | 20.01.2022 |
Now I would like to calculate the mean and average for each article using all available data.
Here I would like to get 2 different levels of granularity. Once the mean and average for each process step and once for all production steps in total (Cycle Time).
How would you do that in Power Query?
Since I need this table a an input for multiple reports, I have to do this in PQ.
First things first - I don't think Power Query is the right place to do that (if possible at all). Power Query is just a data prep/storage engine. You're supposed to do this in the reporting engine using DAX.
Then on the DAX side - can you please show the desired outcome of the calculations?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.