Table for Running Total per Product and Sales Person

[DagmaraG]

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

[johnt75]

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.

[PoweredOut]

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