Forum Discussion
Cumulative area chart based on month name
Hi everyone, I want to create a cumulative area chart based on month name instead of month number. Currently this is my working measure but how can I make it work using month name instead? It won...
Anonymous you can also add month name column in ALL function
Cumulative = CALCULATE( SUM(Table1[Value]), FILTER( ALL( Table1[Month Num], Table[Month Name] ), Table1[Month Num] <= MAX(Table1[Month Num]) ) )Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
parry2k
Super User
Super UserAnonymous you can also add month name column in ALL function
Cumulative =
CALCULATE(
SUM(Table1[Value]),
FILTER(
ALL(
Table1[Month Num],
Table[Month Name]
),
Table1[Month Num] <= MAX(Table1[Month Num])
)
)
Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com