Forum Discussion

mdaamirkhan's avatar
mdaamirkhan
Post Prodigy
5 years ago
Solved

Less than current year should be marked equal 0.

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]   ...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

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