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

1 Reply

  • 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