Dax YTD with Calendar in format YYYYMM

[PDTV]

I have write a YTD measure and it works fine if my columns are Year, Month. However, it doesn't work if I want to use the column yyyymm. Please help me fix it.

Thank you so much

[Ashish_Mathur]

Hi,

If the YYMMM column is from the Calendar Table, then try this

Measure = calculate([Sales],datesytd(calendar[date],"31/12")))

Hope this helps.

[Kedar_Pande · Accepted solution]

For the yyyymm format (Yr_M), you can use a modified approach by transforming the Yr_M values into proper date formats:

SO Amt YTD_FF = 
CALCULATE(
SUM('Table'[SO Amt]),
FILTER(
ALL('Table'),
'Table'[Yr_M] <= MAX('Table'[Yr_M]) && 
YEAR(DATE(LEFT('Table'[Yr_M], 4), MID('Table'[Yr_M], 5, 2), 1)) = YEAR(TODAY())
)
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[PDTV]

Thank you so much! It works perfectly now.

I would like to ask if I don't want Year (Today), how can I change it?