My requirement is to show YTD till December2022 and LTM from Jan 2023.I have written this dax code.But the issue is the filter condition in the first if line ie the current year .
for LTM jan 2023=its calculating only jan 2023 and for LTM feb 2023 its calculating (jan+feb) 2023.Not going back to 2022 .
what changes should i make to the dax.
TEST Z =
var filled_total = IF(MAX('GBLDEVALLDW DateDim'[CalendarDate])=YEAR(TODAY()),
CALCULATE( COUNT( PageUp[FilledDate] ),PageUp[Jobstatus]="Filled",
DATESINPERIOD('GBLDEVALLDW DateDim'[CalendarDate],
MAX('GBLDEVALLDW DateDim'[CalendarDate]),
-12,
MONTH))
,
CALCULATE( COUNT( PageUp[FilledDate] ),PageUp[Jobstatus]="Filled",
DATESYTD('GBLDEVALLDW DateDim'[CalendarDate])))
var filled_internal =IF(MAX('GBLDEVALLDW DateDim'[CalendarDate])=YEAR(TODAY()),
CALCULATE( COUNT( PageUp[FilledDate]),PageUp[Jobstatus]="Filled" ,
PageUp[IsInternalApplicant]="Yes",
DATESINPERIOD('GBLDEVALLDW DateDim'[CalendarDate],
MAX('GBLDEVALLDW DateDim'[CalendarDate]),
-12,
MONTH)) ,
CALCULATE( COUNT( PageUp[FilledDate]),PageUp[Jobstatus]="Filled" , PageUp [IsInternalApplicant]="Yes",
DATESYTD('GBLDEVALLDW DateDim'[CalendarDate])))
return
IF( filled_internal=BLANK(), 0 ,filled_internal/filled_total)