Less than current year should be marked equal 0.

[mdaamirkhan]

Hi All

I need help on below dax . I want If Contract end Date < 2021  should be marked equal 0. screenshot below

Dax: 

Future Relationship = [Total relationship] -[Current Relationship]

[PhilipTreacy · Accepted solution]

Hi @mdaamirkhan 

How are you calculating Contract End Date? Is it a column? Measure?

Try this

Future Relationship = 

VAR _FR = [Total relationship] -[Current Relationship]

RETURN

IF(YEAR([Contracts end date]) < 2021, 0 , _FR)

Regards

Phil