topic Re: Table for Running Total per Product and Sales Person in DAX Commands and Tips

Table for Running Total per Product and Sales Person

DagmaraG — Thu, 11 May 2023 10:45:01 GMT

Hi All !!

I have some, maybe easy for you case 🙂

My data looks like this:

table: SALES

It has many columns, but columns that are relevant looks like this
columns: Date, Sales Person, Product Person ID (unique), Units Sold

I need to create Measure like in a screenshot.

Alternatively I would like to have it as a separate table, cut it out from sales with this new calculation ?

Anyone could help me please.

Many thanks in advance

Re: Table for Running Total per Product and Sales Person

PoweredOut — Thu, 11 May 2023 14:12:21 GMT

Please refer to here https://www.sqlbi.com/articles/computing-running-totals-in-dax/

Re: Table for Running Total per Product and Sales Person

johnt75 — Thu, 11 May 2023 14:14:05 GMT

You could try

Running Total = CALCULATE ( SUM ( Sales[Units sold] ), WINDOW ( 1, ABS, 0, REL, Sales, ORDERBY ( Sales[Date], ASC ), PARTITIONBY ( Sales[Sales person], Sales[Product Person ID] ) ) )

You would need to have a column in the data which uniquely identifies a row. If you don't have one you could use Power Query to add an Index column, and you would need to mark that as the key column in the modelling view.