Forum Discussion

odada11's avatar
odada11
Helper I
3 years ago
Solved

dax

Hello All, I am trying to write a measure that goes thus State Groups = IF ('Crossystate]="Unreconciled", "Unreconciled", if ('crossystate]="paid", "Invoiced", If ('crossystate]="Approved", "In...
Need Help
  • odada11's avatar
    odada11
    3 years ago

    Thank you so much
    i tried it and it returned this error

     

  • TaylorPBI21's avatar
    TaylorPBI21
    3 years ago

    Hi odada11 ,

    Are you making it a calculated column? Try this and amend table name etc to fit your need...😎


    State Groups = SWITCH(
    TRUE(),
    'Table'[Crossystate] = "unreconciled", "Unreconciled",
    'Table'[Crossystate] = "paid", "Invoiced",
    'Table'[Crossystate] = "approved", "Invoiced",
    'Table'[Crossystate] = "unpaid", "NotPaid",
    "Pending"
    
    )

    Many Thanks,

     

    Taylor

     

    LinkedIn: www.linkedin.com/in/taylordownes10 😊

TaylorPBI21's avatar
TaylorPBI21
Resolver I
3 years ago

Hi odada11 ,


Try this...😎

 

New Calculated Column = SWITCH(

 

TRUE(),

[Crossystate]="Unreconciled", "Unreconciled",

[crossystate]="paid", "Invoiced",

[crossystate]="Approved", "Invoiced",

[crossystate]="unpaid", "Notpaid",

 "Pending"

)

 

Many thanks,

 

Taylor

  • odada11's avatar
    odada11
    Helper I
    3 years ago

    Thank you so much
    i tried it and it returned this error

     

    • TaylorPBI21's avatar
      TaylorPBI21
      Resolver I
      3 years ago

      Hi odada11 ,

      Are you making it a calculated column? Try this and amend table name etc to fit your need...😎


      State Groups = SWITCH(
    TRUE(),
    'Table'[Crossystate] = "unreconciled", "Unreconciled",
    'Table'[Crossystate] = "paid", "Invoiced",
    'Table'[Crossystate] = "approved", "Invoiced",
    'Table'[Crossystate] = "unpaid", "NotPaid",
    "Pending"
    
    )

      Many Thanks,

       

      Taylor

       

      LinkedIn: www.linkedin.com/in/taylordownes10 😊

      • odada11's avatar
        odada11
        Helper I
        3 years ago

        Thank you so much for your help, is there a way i can make all the "invoiced" appear as one in a drop down filter rather than have several Invoiced.

        Really grateful for your help