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", "Invoiced",
if ('crossystate]="unpaid", "Notpaid",
 "Pending"
)))
Pls kindly 
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 😊

4 Replies

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