topic Flag for last year same period in DAX Commands and Tips

Flag for last year same period

nemo189 — Fri, 01 Mar 2024 06:31:23 GMT

I have a table with columns , End date period(end date of each period),Start date period(Start date of each period), Period (YYYY-YYYY PXX) .
I have created a measure to identify current year current period(2023-2024 P12) and current year last period(2023-2024 P11).
Current Year Last Period =
VAR MaxDate = MAXX(FILTER('Hold Date', 'Hold Date'[PERIOD_END_DT] + 1 < TODAY()), 'Hold Date'[Release Period])
VAR Year1 = LEFT(MaxDate, 4)
VAR Year2 = MID(MaxDate, 6, 4)
VAR Period = MID(MaxDate, 12, 2)
RETURN
Year1 & "-" & Year2 & " P" & Period
CurrentPeriod =
VAR CurrentDate = TODAY()
RETURN
MAXX(
FILTER(
'Hold Date',
'Hold Date'[PERIOD_START_DT] <= CurrentDate && 'Hold Date'[PERIOD_END_DT] >= CurrentDate
),
'Hold Date'[Release Period]
)

I want to create a flag to mark Current year Current Period as 1 till Last Year Current period.
the out put should be like this

Period	Flag
2022-2023 P5	0
2022-2023 P6	0
2022-2023 P7	0
2022-2023 P8	0
2022-2023 P9	0
2022-2023 P10	0
2022-2023 P11	0
2022-2023 P12	1
2022-2023 P13	1
2023-2024 P1	1
2023-2024 P2	1
2023-2024 P3	1
2023-2024 P4	1
2023-2024 P5	1
2023-2024 P6	1
2023-2024 P7	1
2023-2024 P8	1
2023-2024 P9	1
2023-2024 P10	1
2023-2024 P11	1
2023-2024 P12	1
2023-2024 P13	0
2024-2025 P1	0

Re: Flag for last year same period

lbendlin — Fri, 01 Mar 2024 21:04:19 GMT

Have you considered using the SAMEPERIODLASTYEAR convenience function?

Re: Flag for last year same period

Sahir_Maharaj — Fri, 01 Mar 2024 21:06:23 GMT

Hello nemo189,

Can you please try this DAX:

Period Flag = VAR CurrentPeriod = [CurrentPeriod] VAR LastYearCurrentPeriod = CALCULATE( [Current Year Last Period], DATEADD('Hold Date'[PERIOD_START_DT], -1, YEAR) ) VAR CurrentPeriodDate = MAX('Hold Date'[PERIOD_END_DT])comparison VAR IsWithinRange = CurrentPeriodDate >= CALCULATE(MIN('Hold Date'[PERIOD_END_DT]), 'Hold Date'[Release Period] = LastYearCurrentPeriod) && CurrentPeriodDate <= CALCULATE(MAX('Hold Date'[PERIOD_END_DT]), 'Hold Date'[Release Period] = CurrentPeriod) RETURN IF(IsWithinRange, 1, 0)