Forum Discussion
YTD Cumulative for weekly figures
I am trying to create measure for the cumulative columes. Below is the DAX code I wrote. As you can see in the last colume of the visual, it is still showing by week numbers not cumulative by week...
Thanks a lot for your reply.
Pmorg73
Post Patron
Post PatronIt would be worth your while quickly researching creating calendars (loads on youtube - check Enterprise DNA). It gives you a new table that you make a relationship to your data table with. Then you have Time inteligence (as they call it) and you can measure against a set calendar range, using days, months, years or whatever.
eg
create Table button and enter this:
calendar = CALENDAR(DATE(2018,04,01),date(2021,03,31))
from here create columns for months, weeks, Financial year months, month numbers. Lots and lots of options that you adjust for your requirements. I typically have a month number; financial year month number; year; quarter, Day number; Day of week number
eg -
month number = month('calendar'[Date])
Day = DAY('calendar'[Date])
Checked calendar table out. Great!