Help with New Measure Data Column

[dtango9]

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]

It worked!  Thank you 😀

[SamInogic]

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 crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[dtango9]

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]))

[amitchandak · Accepted solution]

@dtango9 , a new columns

Switch( True(),

isblank([Vendor Name]) &&  containsstring([Expense Description], "prepaid") , "PREPAIDS" ,

isblank([Vendor Name]), "Accrual/Reclass" ,

[Vendor Name]

)