Forum Discussion
Solved
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...
dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)
dtango9 , a new columns
Switch( True(),
isblank([Vendor Name]) && containsstring([Expense Description], "prepaid") , "PREPAIDS" ,
isblank([Vendor Name]), "Accrual/Reclass" ,
[Vendor Name]
)