Forum Discussion

jludwick's avatar
jludwick
Frequent Visitor
3 years ago
Solved

DAX Function

I'm trying to make a DAX function that will show two different values based on the current point in time.    I have a Sales Data table with "Actuals" and "Budget"   So if it's currently March, wh...
Need Help
Tips and Tricks
Tutorial Requests
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi jludwick 

     

    Try like:
    Measure =
    IF(
        MONTH(MAX(DateTable[Date]))<MONTH(TODAY()),
       [ActualsMeasure],
       [BudgetMeasure] 
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi jludwick 

 

Try like:
Measure =
IF(
    MONTH(MAX(DateTable[Date]))<MONTH(TODAY()),
   [ActualsMeasure],
   [BudgetMeasure] 
)