Forum Discussion
Calculating Remaining Value
Take the cumulative of table 2 and then try the diff
CALCULATE(sum(table2[received]),filter(table2,table2[received]<=max(table2[ Date])))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
I am not sure that is what I am looking for. Maybe this is what you are suggesting, but what I am thinking now is
Create a column in table 2 that is the total receieved to date. That being a matching ID and date <= date of the row. Then I can take the difference from table 1.
Can you help with creating that new column sums the recieved of rows with matching the IDs and has a date <= date of the row?