Forum Discussion

bedata1's avatar
bedata1
Frequent Visitor
3 years ago
Solved

Multiple Time Variables with If Return

Hi Community,   I want to create a DAX formula that shows the following: If Date <= Today, then show the "amount" from the "G/L Entry" table and if Date > Today, then show the "amount" from the "B...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi bedata1 

     

    try like:

    IS LE = 
    var TodayDate = TODAY()
    var ActualAmount = 
    CALCULATE(
        SUM('G/L Entry'[amount]),     FILTER('Date','Date'[Date] <= TODAY())
    )
    var BudgetAmount =    
    CALCULATE(
        SUM(Budget[Amount]),
        FILTER('Date','Date'[Date] > TODAY())
    )
    return
    IF(
        MAX(Budget[Date]) > TodayDate,
        BudgetAmount,
        ActualAmount
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi bedata1 

 

try like:

IS LE = 
var TodayDate = TODAY()
var ActualAmount = 
CALCULATE(
    SUM('G/L Entry'[amount]),     FILTER('Date','Date'[Date] <= TODAY())
)
var BudgetAmount =    
CALCULATE(
    SUM(Budget[Amount]),
    FILTER('Date','Date'[Date] > TODAY())
)
return
IF(
    MAX(Budget[Date]) > TodayDate,
    BudgetAmount,
    ActualAmount
)