Forum Discussion

Mystery's avatar
Mystery
Helper I
6 years ago

Cumulative Sum using DAX

Hi,   I am trying to compute the cumulative sum using below DAX formula:   Cumulative SUM= VAR MAXDATE = CALCULATE (value(LEFT(MAX ('Date'[DateKey]),6) )) RETURN IF ( LEFT(MIN('Revenue'[DateK...
Show and Tell
pa_trick67's avatar
pa_trick67
Helper I
6 years ago

Hi Mystery 

I suggest you to convert this datekey into date in power query (you can use add column from example) and then compute cumulative Sum with date.

Best

Patrick

  • Mystery's avatar
    Mystery
    Helper I
    6 years ago

    Date Key column actually holds a date in YYYYMMDD format only.

     

    Also this DAX is written in tabular model and not using Power BI desktop.Thats the approach in my project.

     

    The irony is although the same formula works in Power BI however does not yield correct results when written in tabular model.

     

    Any pointers are appreciated.