Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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