Forum Discussion
JamesGordon
Helper II
Helper IICumulative Total
Hi, I am really struggling to get my montly sales to cumulative total. I have tried numerous DAX and varations on date tables but still cannot get the data to count cumulatively. In order to ...
To be able to create YTD measures you need to have a calendar in your model. Having dates in your fact tables and operating on them directly is a sure way to fail.
Please follow the guidelines of dimensional design (star schema) and you'll be writing simple and correct DAX in no time.
Best
D
Please follow the guidelines of dimensional design (star schema) and you'll be writing simple and correct DAX in no time.
Best
D