If function returning wrong value

[dokat]

Hi,

I have below if function where CY is equals to 12/31/2021 it should return Last Year. However formula returns 0. Anyone can help with what's causing this error?

Measure = if(('Tier'[CY])=DATE ( YEAR ( SELECTEDVALUE ('Tier'[CY]))-1, 12, 31 ),"Last Year",0)

[TheoC]

Hi @dokat 

Can you try:  

Measure = IF ( Table[Column] = DATE ( 2021, 12, 31 ) , 1 , 0 )

Hope it helps.

Theo

[dokat]

@TheoC Unfortunately it didnt work. And i'd like to make the lookup value to be dynamic rather than hard coded as it will change over time. '

Where formula equals to = 'Tier'{CY] (12/31/2021) Thanks

[TheoC]

@dokat can you show me the screenshot of the error? 

[dokat]

@TheoC  Please see below

[Anonymous · Accepted solution]

Hi @dokat ,

Try the calculated column

Column = IF([CY]=DATE(2021,12,31),"Last Year","0")

Calculated columns and measures are different, please note.

What is the difference between Power BI calculated columns and measures? - TrueCue.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.