Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I think this might be easy:
I need a chart showing the current year monthly total and I want to have a "shadow" part in the chart showing the max and min of the last 5 years to see how this year is going.
So I think I need to calculate the total per month and then the 5 year max and min for each month of the year but I cannot figure out the measure.
thanks!
Solved! Go to Solution.
@viltxes14 , refer if this can help
minx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])
maxx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])
@viltxes14 , refer if this can help
minx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])
maxx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])
Hi Amit,
It works fine with the total per month. Do you know how can I do it if I need the daily average per month?
thanks a lot,
kind regards,
Thanks! it works perfect!!!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |