Forum Discussion
TotalYTD function as a graph for different years
Hello guys, I want to build a measure to show the revenues per month for each year. I have done that, but they should be summarized each month. I have two examples for that, how it should loo...
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
The first one is how it is actually, the screenshot below is how it should be (revenues are summarized). And there will compare the different years.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
