Forum Discussion
Column averages table with ascending values and dynamic date slicer
Hi everyone, I have a table that contains data with daily values like this: Now I want to create a table with the averages in ascending order that adjusts itself when moving the date ...
V-lianl-msft
Community Support
Community SupportHi Marty_H ,
Try using "Unpivot" in the query editor, and then create a measure to calculate the average.
https://radacad.com/pivot-and-unpivot-with-power-bi
The calculated table and calculated column are always static, and the value cannot be changed dynamically according to the slicer. Only measure will change dynamically based on the current row context.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.