Forum Discussion

Gwhiz's avatar
Gwhiz
Icon for Helper I rankHelper I
7 years ago
Solved

Need help modifying dax formula for cumulative sumx

I am having trouble getting this formula to reset every month as it doesn't go to 0 but when I have it reset each year it works fine:   Business cumulative = SUMX( FILTER( ALLSELECTED(...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my solution PBI file from here.

    Hope this helps.

Gwhiz's avatar
Gwhiz
Icon for Helper I rankHelper I
7 years ago

v-yuta-msft   Any other way than creating an index column?? I don't think that would be the best way to go about it, if you see my last formula it is exactly what I want but I need it changed from descending to ascending.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Share the link from where i can download your PBI file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      You may download my solution PBI file from here.

      Hope this helps.

      • Gwhiz's avatar
        Gwhiz
        Icon for Helper I rankHelper I
        7 years ago

        Ashish_Mathur 

        One question though, can you not use date hierarchies in this scenario or was this just your preference? would the date order table be necessary in a bigger dataset/real scenario?