Calculate based on certain Date criteria similar to previous month
Good day, Been struggling to figure out what is the best way to calculate these. Begin Inv : the count of open items to start the specific month Closure: the number of items closed in the specific month What I want to have is a measure that will calculate any placement that is open on Jan 1st of 2021. Which considered as the begin inventory for the start of the month and if the close date is =<12-31-2020 (for example) it would not count. What I have so far: Begin Inventory # = CALCULATE(COUNTROWS('sample'),'sample'[Status] = "Open") and another calculation that would determine how many were closed in a month eg. 01-01-2021 to 01-31-2021. which I believe I was able to do so by doing. Closure: CALCULATE(COUNTROWS('sample'),'sample'[Status] = "Closed" ) Please see the pbix file here