Forum Discussion
Solved
Modeling for a week
Hey community,
I do this chart :
It's an average of volume by hour and by days (monday, thuesday, etc.)
In order to acheive this chart, I use the followings measures (7 times!!!!!):
Volume thursday= CALCULATE([avergae volume dayly],TBL_Day[#]=4)
Do you have a bettre soluton than copy paste 6 time this formula... I am not sure to use the right chart do to it, because, when you use the Matrix table, it works amazing (juste one measure) :
thanks for your help
Hi Ben_137ch205
You can use the weekday as a legend, instead of 7 measures :
pbix with example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
3 Replies
Hi Ben_137ch205
You can use the weekday as a legend, instead of 7 measures :
pbix with example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks!!!
Happy to help 🙂
