Forum Discussion

nanutum's avatar
nanutum
Icon for Helper I rankHelper I
6 years ago
Solved

LASTDATE ERROR MDXSCRIPT PLEASE HELP

i have 2 meaure can used normally  but today get error below please help     Stock_Case_LastDate = SUMX ( VALUES ( 'Sold to party' ), CALCULATE ( SUM ( Stock[Case]),LASTDATE( ( Stock[Sto...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hello @nanutum ,

    Can you try modifying the DAX expression for the measure as follows:

    Stock_Case_LastDate = 
var maxDate = CALCULATE(MAX(Stock[Stock_Date]))
RETURN
CALCULATE(SUM(Stock[Case]), ALL(Stock), Stock[Stock_Date] = maxDate)

    Thank you

    Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nanutum ,

Since there is no data sample and expected output , I’m not sure why the LASTDATE() function not works.

As this article said, 'firstdate' and 'lastdate' function not works if your date table contains duplicate records.

If you're using a fact table where the same date can be repeated more than once, you should use MIN and MAX instead.

 

If you have any further questions ,please upload your pbix file after doing mask sensitive data.

 

Best Regards,

Eyelyn Qin