Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Accumulated by dates

Hello community, I hope you can help me with this question I am trying to look for the accumulated of our stock, without emabargo to program in DAX I am not the best, I could only do this Measure...
JChai's avatar
JChai
Icon for Advocate I rankAdvocate I
4 years ago

Hello Syndicate_Admin,

 

I believe that you are talking about cumulative sum. Here's how you can do it with DAX:

 

CUM_DIFF = 
CALCULATE (
SUM('TABLE'[Diferencias]),
FILTER(ALL('TABLE'),
'TABLE'[MONTH NUM] <= EARLIER ( 'TABLE'[MONTH NUM] )
)
)

 

Notice that I have generated an additional column `MONTH NUM` which help in sorting the `MONTH` (Text) column. Below is how my final table looks like.

Here are the link that you might find helpful:  Solved: Cumulative Sum, DAX - Microsoft Power BI Community

 

Hope this help!

 

Best,

JKC

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    It is just what I want to do, without emabargo, my data is not separated by months, the data is individual data and is grouped depending on the month, as seen in the photo, try to make a column with the number of the month, but I do not know if it works that way

    And this columa I made with a Month

    It is also worth mentioning that the production and the entries are in two separate tables

    • JChai's avatar
      JChai
      Icon for Advocate I rankAdvocate I
      4 years ago

      Syndicate_Admin 

      Yes, it can be done. You just need to make sure that you have define the right schema relationships for working with both LAFI & TPDM tables. A simple illustration of this schema is presented as below.

      The results presented from the simple tables in Power BI is shown as below.

      The DAX formula uses are the same without much complications, thus, you should be able to handle easily. 

      Best,

      JKC

      ---

      FYI: LAFI table has 141 rows & TPDM table has 145 rows.