Power BI - ACCUMULATED VALUE AS FILTER WITH VARIOUS CRITERIA

0

I have a stock database with four columns: Date - Product - Entries - Sales. 1) The 1st column contains the dates, all of them always with the 1st day of the month and year: 01/01/2010 - 01/02/2010. Dates start on 01/01/2010 and run until 01/11/2018. The dates repeat several times in sequence as we have several sales on the same day. 2) The second column contains the names of the products, which of course repeat themselves many, many times, even on the same day, as there are sales on a daily basis. 3) The 3rd column has the input values in the stock. For each product there are several launches during the months of the years. 4) The 4th column has the outputs of each sale made. I need to create a 5th column, or a measure, for each line to return the accumulated value taking into account each product, input and output.

I've grouped in Power Query by date as per image. It was better this way. Only the accumulated per line is needed for each product. As picture below

    
asked by anonymous 07.12.2018 / 14:30

1 answer

0

I've grouped in Power Query by date as per image. It was better this way. Only the accumulated per line per product is missing.

    
07.12.2018 / 17:06