Measure for if statement does not work when using time series

[Anonymous]

Hi there,

I would like some help please. I have the following sample financial data for the years 2019, 2020, 2021. Note that I have a Date Dimension table in my model already, I put the below as reference for the data.

I have SUM measures for the Actual, Budget and Estimates columns currently. I'm creating an additional measure for the following logic:

Actual_Expense_Budget =

IF(

     ALLSELECTED(DimDate[Year]) < YEAR(TODAY()),

     [Monthly (Actuals)],

     IF(

         ALLSELECTED(DimDate[Year]) = YEAR(TODAY()),

         [Monthly Estimates],

         [Monthly Budgets]

      )

  )

This gives me the correct result when filtering between years (I have a Year filter on my page).

However I get the following error when adding the measure to a chart with YEAR as an axis from my DimDate table:

Any help would be really appreciated. Thank you

[amitchandak · Accepted solution]

@Anonymous , You can have measure like this

Actual_Expense_Budget =
IF(
Max(DimDate[Year]) < YEAR(TODAY()),
[Monthly (Actuals)],
IF(
Max(DimDate[Year]) = YEAR(TODAY()),
[Monthly Estimates],
[Monthly Budgets]
)
)

But this will check row context

[Anonymous]

Great, thank you so much. I didn't realise it could have been that simple!