Forum Discussion
Anonymous
6 years agoNot applicable
measure
Hello. I have a table #Net with a StartDate and an EndDate. What I want to do is a measure that says how many contracts were active at the end of each time period.
I've used this measure: Active Month End = CALCULATE(COUNTROWS('#Net'); FILTER('#Net'; '#Net '[Start Date] <= LASTDATE('Date'[Date]) && [End Date] >= FIRSTDATE('Date'[Date])))
This code works, but I know the raw data quite well and can see that the number is not correct. (typically 160000 instead of 158000). How can I improve the measure to work correctly?
New to Power BI so trying to learn here