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
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
)

Forum Discussion

Multiple Time Variables with If Return

Related content

Return multiple variables

issues with RETURN statement from variables

Return multiple values

Measure to return multiple values

Summarize multiple variables