Forum Discussion

chrisalexander's avatar
chrisalexander
Regular Visitor
6 years ago

DAX expression - Token Literal Expected error

Hello Everyone!

 

Im running into an issue with the formula listed below.  Image below as well to show where the error is showing.  I am still new to learning DAX expressions and new to learning these type of errors in Power BI.  The colum type I text since I am trying to either pass a number or text value depending on the sitation.

 

Also my first post here. So bear with me on learning the proper information to write these.

 

if [Subsidiary]=100 && [Recharge Subsidiary]= 100 then "OVERHEAD" else if [Subsidiary]>0 && [Recharge Subsidiary]>0 then "00"&[Recharge Subsidiary] else if [Subsidiary]="" && [Recharge Subsidiary]>0 then "00"&[Recharge Subsidiary] else if [Subsidiary]=100 && [Recharge Subsidiary]="" then "OVERHEAD" else if [Subsidiary]="" && [Recharge Subsidiary]="" then "OVERHEAD" else if [Subsidiary]>0 && [Recharge Subsidiary]="" then "00"& [Subsidiary] else "TBD"

 

 

 

2 Replies

    • chrisalexander's avatar
      chrisalexander
      Regular Visitor
      6 years ago

      camargos88 Thank you so much.  It worked!  Looks like an opportunity to do a little bit more reading up on DAX exprsessions and learning the syntax behind it.  Thank you again.