Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello All, I am trying to write a measure that goes thus
Solved! Go to Solution.
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 😊
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
Thank you so much
i tried it and it returned this error
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 😊
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
90 | |
35 | |
35 |
User | Count |
---|---|
153 | |
99 | |
82 | |
63 | |
54 |