Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Get Formula to Work

Hi - I have this formula for a column in PowerBI:  =IF(LEFT(vBI_ClientBankAccounts[Bank Account CUSIP],2)= "CD", "CD", IF(LEFT(vBI_ClientBankAccounts[Bank Account CUSIP],3)= "TBS", "TBS", "AMMA")) ...
Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi !

    Sorry, you need to remove, the enclosed single quotes from column name;

    =IF(LEFT('vBI_ClientBankAccounts'[Bank Account CUSIP],2)= "CD", "CD", IF(LEFT('vBI_ClientBankAccounts'[Bank Account CUSIP],3)= "TBS", "TBS", "AMMA"))

     

    Hopefully above DAX will work.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Hasham - thanks for getting back to me. I tried this: 

=IF(LEFT('vBI_ClientBankAccounts'['Bank Account CUSIP'],2)= "CD", "CD", IF(LEFT('vBI_ClientBankAccounts'['Bank Account CUSIP'],3)= "TBS", "TBS", "AMMA"))
 
Now I get this error with the red squiggly lines below the fields:
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Worked perfect, thank you so much!