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.

HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Hi !

Please try using below DAX, enclosed table name in single quote;

 

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

 
Regards,

Hasham

  • 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:
     
    • HashamNiaz's avatar
      HashamNiaz
      Icon for Solution Sage rankSolution Sage
      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

      Worked perfect, thank you so much!