IF date apply value

DAX DAX Calculations
1

Hi guys, attempting to apply a value only if year is 2019, if my shipdate is = 2019 apply one value, if not another value.

Total Costs + 25% =

Var YearToday =YEAR(2019)

Return

If(YearToday,[Total Costs]+ [Total Costs]*0.25,[Total Costs])

2

Hi Tyronne,

There are probably a few ways to resolve this but it all depends on what you need…
But first please check the result for your YearToday in a card or table visual:

You’ll see that this doesn’t actually return the year 2019. You can check the documentation here: https://docs.microsoft.com/en-us/dax/year-function-dax

If you use the Dates[Date] in a table you could do something like:

Total Costs + 25% = 
VAR YearToday = YEAR( DATE( 2019, 1, 1 ) )
VAR TotalCosts = [Costs]
RETURN

IF( YEAR( MAX(Dates[Date]) ) = YearToday,
     TotalCosts + TotalCosts *0,25 ,
     TotalCosts
)

Say your YearToday alway needs to be the current year then you can change it into YEAR ( TODAY() )

1 Like
3

Thanks very helpful

What I have noticed when you select a year from the slicer it still applies the 0.25 for example to 2018 even though its should only apply to any value in 2019… any thoughts

4

Thanks very helpful

Managed to figure out this

Total Costs + 25% = if(CALCULATE([Total Costs],Dates[Year]>=“2019”),[Total Costs]+ ([Total Costs]*0.25),[Total Costs])