Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
No matter what I try, I can't get a simple cumulative sum using TOTALYTD to work. I've read the dozend or so other threads with the same issue but nothing helped so far. Total YTD always just shows the value from the amount column:
When I create a visual using Calendar[Date] vs Data[Total YTD] it just displays the sum for each month:
What am I missing here?
Solved! Go to Solution.
Hi @3rdcycle,
The question is that you are making a YTD column, you must use the TOTALYTD as a measure, there is a big difference in making the use of the formula in a column or in a measure based on it's context.
Create a new measure with the same formula and add it to your visuals and should give the expected results.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @3rdcycle,
The question is that you are making a YTD column, you must use the TOTALYTD as a measure, there is a big difference in making the use of the formula in a column or in a measure based on it's context.
Create a new measure with the same formula and add it to your visuals and should give the expected results.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks! This works, even though I could swear I saw a video where someone added a cumulative sum column using TOTALYTD.
The only problem now is that my Calendar contains future dates causing TOTALYTD to compute results all the way to the end of the year instead of to today (as the name would imply). Any solution for this?
Hi @3rdcycle,
The TOTALYTD does not compute until the end of the year computer from the beginning of the year until the selected date what usually happens is that if your data finish in July and you have your visuals until December the August till December will always show the same value.
Don't understand what is your question.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @3rdcycle,
Can assume that you were abble to solve your issue.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |