Issue on MDX/DAX Cumulative by Day

[weiyann83]

Need help on MDX/DAX expert, I want to perform cumulative day by day, not sure why 7/14/2021 start onwards all cumulative data mess up.

Expected Result on  7/14/2021 data should be 7030882 + 1080000 = 8,110,882

Formula:

Cumulative Daily Progress =

CALCULATE (

SUM ('Test Run'[Pass Count]), DATESMTD ('Test Run'[Updated Date])

)

[daxer-almighty]

Once again 'cause I see you're not carefully reading my messages: https://dax.guide/DATESMTD

Read the article at the link and you'll know why you're getting wrong results.

[CNENFRNL]

Debug =
CONCATENATEX(
    DATESMTD( 'Test Run'[Updated Date] ),
    'Test Run'[Updated Date] & ":"
        & CALCULATE( SUM( 'Test Run'[Pass Count] ) ),
    "|"
)

[weiyann83]

Not sure why 7/14/2021 onwards look back 7/7/2021 all value change from 730000 to 420000

[CNENFRNL]

I've shown you a way to debug; make your own efforts to look into it.

[daxer-almighty]

MDX? Are you working with Multidimensional models or with Tabular where DAX is used?

Read this and you'll know why it's messed up.

[weiyann83]

tabular, sorry is DAX.