Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How to combine 2 expression into 1 ?

Hi All   I have below 2 seperate expression :-   Show Last 3 Yr = IF ('DATE'[Year] >= Year(TODAY()) - 3, 1, 0) Show Last 4 Yr = IF ('DATE'[Year] >= Year(TODAY()) - 4, 1, 0)   May i know how...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    That's because it needs to be defined as a new calculated table, not a measure or calculated column. See the example I attached previously.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

That's because it needs to be defined as a new calculated table, not a measure or calculated column. See the example I attached previously.