Forum Discussion

dtango9's avatar
dtango9
Helper II
2 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    dtango9 , a new columns

     

    Switch( True(),

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

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

    [Vendor Name]

    )

SamInogic's avatar
SamInogic
Super User
2 years ago

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/

  • dtango9's avatar
    dtango9
    Helper II
    2 years ago

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