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

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

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

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

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