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.
select the Sprint Name(s) based on Today <= Sprint Start Date and Today >= Sprint End Date (and not in the future) then add up the number of sprints selected (eg. 4 sprints selected) and divide the sum of the Sprint Points Done by that number. 381/4 in other words
Do I have a typo in here? "Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2."
There's a ( missing in both the last Today expression
TODAY()
Proud to be a Super User!
Paul on Linkedin.
Not enough coffee :)... thanks!!
I made the adjusment
@singleton2787 , Try measure like
divide( calculate(Sum(Table[Sprint data points]), filter(Table, [Sprint Start Date]<= Today() && [Sprint End Date]>= Today)),
calculate(Distinctcount(Table[Sprint Name]), filter(Table, [Sprint Start Date]<= Today() && [Sprint End Date]>= Today))
)
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 |
---|---|
112 | |
99 | |
75 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |