Multiple Time Variables with If Return

[bedata1]

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 "Budget" table.

Date is linked to postingdate from the "G/L Entry" & "Budget" tables.

Visualization: Matrix with Month column

Folgende DAX habe ich erstellt, jedoch funktioniert diese nicht richtig:

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(FILTER(Budget,Budget[Date] > TodayDate),BudgetAmount,ActualAmount)

Can anybody help me with creating this DAX formula?

Thank you for your help.

[bedata1]

@FreemanZ Thank you for your awsome help, the DAX formula is working!

[FreemanZ · Accepted solution]

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

)