Forum Discussion
TotalYTD function as a graph for different years
hi, Anonymous
After my research, you could try this way:
Step1:
Add a year and month column for date column
Step2:
Use this formula to create a TotalYTD Measure
Measure = CALCULATE(SUM(Table1[Qty]),FILTER(ALL(Table1[Month]),Table1[Month]<=MAX(Table1[Month])))
Step3:
Drag month field into X-Axis and Year field into Legend
Result:
here is pbix file, please try it.
Best Regards,
Lin
hi, Anonymous
After my research, you could try this way:
Step1:
Add a year and month column for date column
Step2:
Use this formula to create a TotalYTD Measure
Measure = CALCULATE(SUM(Table1[Qty]),FILTER(ALL(Table1[Month]),Table1[Month]<=MAX(Table1[Month])))
Step3:
Drag month field into X-Axis and Year field into Legend
Result:
here is pbix file, please try it.
Best Regards,
Lin
That works perfectly, thank you very much!!
Is there an option to cut the graph in 2019 for the months in the future?
So when we have February 2019, the graph should only show the two months, actually it goes to linear line over the future months.