Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |