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, what DAX function can I make so that I can make a matrix that looks like the following?

 

Month

JanFebMarAprMay JunJulAugSepOct
Sales CompanyActualsActualsBudgetBudgetBudgetBudgetBudgetBudgetBudgetBudget
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] 
    )

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi jludwick 

     

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