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.

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

VahidDM 

I get below error :-

 

 

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    admin11 

    Set No. Year is a parameter.

     

     

    define a parameter and then use that in the formula same as my file.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/