topic Does not start with - DAX expression in DAX Commands and Tips

Does not start with - DAX expression

Anonymous — Wed, 08 Feb 2023 13:28:55 GMT

Hi! I'm looking for help on how to write a 'does not start with' DAX expression.

This is what I have right now, but doesn't seem to work:

Total Sales & Credit Memos = CALCULATE( [Total Amount], (LEFT('CONSOL GLENTRY'[Document No_], 2) <> "GJ" )

I'm looking to calculate all documents that 'do not' start with "GJ".

Any help would be appreciated!

Christina

FreemanZ — Wed, 08 Feb 2023 15:44:16 GMT

hi Anonymous

try like:

Total Sales & Credit Memos =

CALCULATE(

[Total Amount],

FILTER(

ALL('CONSOL GLENTRY'[Document No_]),

LEFT('CONSOL GLENTRY'[Document No_], 2) <> "GJ"

)

smpa01 — Wed, 08 Feb 2023 15:48:32 GMT

Anonymous wrap in MAX

Total Sales & Credit Memos = CALCULATE( [Total Amount], (LEFT(MAX('CONSOL GLENTRY'[Document No_]), 2) <> "GJ" )