topic Re: Multiple Time Variables with If Return in DAX Commands and Tips

Multiple Time Variables with If Return

bedata1 — Thu, 09 Feb 2023 09:51:45 GMT

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.

Re: Multiple Time Variables with If Return

FreemanZ — Thu, 09 Feb 2023 10:22:49 GMT

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

)

Re: Multiple Time Variables with If Return

bedata1 — Thu, 09 Feb 2023 12:43:51 GMT

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