Forum Discussion

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
3 years ago

DAX command issue with IF and LEFT

Amount Including Tax = If(Left(Lines1[Document Number],3) = "PCM", -1 * Lines1[Total_Amount_Incl_VAT], Lines1[Total_Amount_Incl_VAT])   Here is my command above, I am trying to look up a document ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

thomas_coltrain 

This code can be used for a calculated column in the table 'Lines1' not as a measure.