Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
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.
Please refer to here https://www.sqlbi.com/articles/computing-running-totals-in-dax/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |