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.

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

    admin11 

     

    Have you checked this file: https://gofile.io/d/f4TKg8

     

    let me know if you face with any issue.

     

    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/

     

     

  • 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/