Forum Discussion
Summarize table by a DimDate table
Anonymous ,
Each row is a transaction. The table shows when the quantity of something had entered and left each group.
I want the "stock" in each group, each day. So for each day, sum quantity for the rows where
IN <= day && OUT > day
For group A, on 03/01/2018 you have 4 units (1º, 2º, 3º and 5º row, 4º row does not match the condition).
The expected result would be something like:
There's no "day" column in your sample data. Could you clarify more details about your logic?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yuta-msft ,
yeah, sorry. "Day" refers to every day in a calendar, I guess the best way to do this is with a calendar table not-connected to the main table.
The main table gives the IN/OUT date and the quantity, but I need to calculate the stock for every day, so another calendar table is needed.
Anyone knows how to calculate the stock with this logic in DAX?