DAX expression - Token Literal Expected error

chrisalexander — Wed, 12 Aug 2020 13:59:01 GMT

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"

Re: DAX expression - Token Literal Expected error

camargos88 — Wed, 12 Aug 2020 15:34:44 GMT

chrisalexander ,

Use and instead of &&.

Power Query uses and and or

DAX uses && and ||

Re: DAX expression - Token Literal Expected error

chrisalexander — Wed, 12 Aug 2020 15:39:07 GMT

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.

topic DAX expression - Token Literal Expected error in DAX Commands and Tips

DAX expression - Token Literal Expected error

Re: DAX expression - Token Literal Expected error

Re: DAX expression - Token Literal Expected error