DAX Function

[jludwick]

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	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct
Sales Company	Actuals	Actuals	Budget	Budget	Budget	Budget	Budget	Budget	Budget	Budget

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[FreemanZ · Accepted solution]

hi @jludwick 

Try like:

Measure =

IF(

    MONTH(MAX(DateTable[Date]))<MONTH(TODAY()),

   [ActualsMeasure],

   [BudgetMeasure] 

)