I want to create a measure with if else. The logic step is to check if a month is older than March, if that is the case the column uniquePageViews should be selected else the colum total engagers, but if I check March the field is always blank and I don't know why.
TotalEngager or UniquePageviews =
VAR month= SUM('X'[Date (month)])
VAR uniquePageviews = SUM('X'[UniquePageViews])
VAR TotalEngagers = 'Measure Table'[Total Engagers]
RETURN IF.EAGER(month > 202203, uniquePageviews, TotalEngagers)