i wanted to display a measure that shows only a fraction of a cumulative sum based on Year field (e.g. 2022)
I created the folowing measure but I don(t find the right result
Go to Solution.
@zzinoun , If you have a date I will suggest YTD
example with help from date tbale
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
using year and month
YTD= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Month] <= Max('Date'[Month]) ))
using day of year
YTD= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Day of Year] <= Max('Date'[Day of Year]) ))
you can use allselected in place of all if needed
View solution in original post
I don't have a date table only a column.
is there something to add to the measure in order to retrieve only the max value per month ?
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!