Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Does not start with - DAX expression

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( [Tot...
  • smpa01's avatar
    smpa01
    3 years ago

    Anonymous wrap in MAX

     

    Total Sales & Credit Memos = 
CALCULATE( 
        [Total Amount],
        (LEFT(MAX('CONSOL GLENTRY'[Document No_]), 2) <> "GJ"
)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous wrap in MAX

 

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