Forum Discussion
Help with New Measure Data Column
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 |
dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)
4 Replies
dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)
Hi dtango9
You can create a column with below DAX expression,Vendor Name Updated = IF('Table'[Vendor Name] = BLANK() && LOWER('Table'[Expense Description]) = "prepaids" , "PREAIDS",IF('Table'[Vendor Name] = BLANK() && not (LOWER('Table'[Expense Description]) = "prepaids") , "Accrual/Reclass",'Table'[Expense Description]))Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at [email protected]
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"...
New Master Name = IF('finance ExpensesWithAccountDescriptions'[Originating Master Name]=BLANK() && LOWER('finance ExpensesWithAccountDescriptions'[Description])="PREPAIDS","PREPAIDS",IF('finance ExpensesWithAccountDescriptions'[Originating Master Name] = BLANK() && NOT (LOWER('finance ExpensesWithAccountDescriptions'[Description]) = "PREPAID"), "Accrual/Reclass", 'finance ExpensesWithAccountDescriptions'[Originating Master Name]))
It worked! Thank you 😀
