I have a sample data with Date,Location,Product ID and Qty, I wanted to have cumulative value of Qty in a given location for a product by Date (data and Result is given below)
Go to Solution.
As a calc column,, try
VAR mydate = [Date]
SUM ( Table1[Qty] ),
ALLEXCEPT ( Table1, Table1[ProductId], Table1[Location] ),
Table1[Date] <= mydate
View solution in original post
Thanks you for the support, it works
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.