Could someone please show me how to get the average of the “duration” of each day using MDX? For example, the average of all the values of duration column of Feb 11 2022, etc.
In my case, the date is a dimension called “Time”, “duration” is a measure.
Thanks
Try using this formula when creating new calculated measure:
Avg(
[NNN].[NNN].Members,
[Measures].[duration]
)
Martins / eazyBI
