Forum Discussion

JamesGordon's avatar
JamesGordon
Icon for Helper II rankHelper II
6 years ago

Cumulative Totals

Hi,   I am struggling to calculate cumulative totals. Hopefully someone can help!   I have a measure that i have created to calculate the total value of sales YTD (fromt Oct 2019 to today) - this...
JamesGordon's avatar
JamesGordon
Icon for Helper II rankHelper II
6 years ago

Power Bi appears to have automatically recognised my "Inv Dates" as dates - screenshot below

However if i use the "Inv Date" as the X-axis with your DAX as my measure it still produces the graph as per my previous post and doesnt accumulate the values?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
You should never, ever, ever rely on automatic dates in Power BI. Simple as that. If you want to know why, you can do to www.sqlbi.com and find the articles by The Italians that will explain to you in detail why this reliance is a bad idea.

Best
D