Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I'm looking to have the column Vendor Name, if (blank), return the text "PREPAIDS" if column Expense Description contains the text "PREPAIDS". I would also like Vendor Name, if (blank), if Expense Description does not contain the text "PREPAIDS"/all else return "Accrual/Reclass" if it does not contain the text "Prepaids".
What is currently shown:
Vendor Name | Expense Description |
(blank) | PREPAIDS |
Bob's Diner | Food |
(blank) | Accrual |
Super Sally's | Sports Apparel |
(blank) | Expense Reclass |
What I would like shown:
Vendor Name | Expense Description |
PREPAIDS | PREPAIDS |
Bob's Diner | Food |
Accrual/Reclass | Accrual |
Super Sally's | Sports Apparel |
Accrual/Reclass | Expense Reclass |
Solved! Go to Solution.
@dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)
It worked! Thank you 😀
Hi @dtango9
You can create a column with below DAX expression,
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at crm@inogic.com
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi, This is what I have and it's only returning "Accrual/Reclass"...
@dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
104 | |
80 | |
66 |