Struggling to create a measure based on current year

[lprabhal]

Hi Everyone,

I am a newbie to PBI and I am struggling to create a simple measure on a column. 

I have a date column CTT sign date and I am trying to create something like this.

If CTT sign date is current year then (measure1 * 1.52) - measure1 is a field from a table

IF(YEAR(VALUES('FACT Sales Pipeline'[CTT Sign Date])) = YEAR(TODAY()),(SUM('FACT Sales Pipeline'[Converted Booking]) * 1.52),0)

and this is giving me an error while displaying the view

"A table of multiple values was supplied where a single value was expected" 

I have to use Values here because when i used Year('FACT Sales Pipeline'[CTT Sign Date]) this throwed me error saying "Cannot find name"[CTT Sign Date]

Can someone please help me here

[lprabhal]

Great! it's working, much appreciate your help

[Shaurya · Accepted solution]

Hi @lprabhal,

Since you have to perform this operation for every date you should create a DAX column and not a measure. You can use:

Result = IF(YEAR('Table'[Date])=YEAR(TODAY()),'Table'[Field]*1.52,0)

Works for you? Mark this post as a solution if it does!
Check out this post of mine: Forecast Period - Previous Forecasts 
Spare some time to read: How to Export Telemetry Data from Azure IoT Central into Power BI