Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
22 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
31 | |
29 | |
18 | |
18 |