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.
Hi Community!
I'd like to ask if it is possible for you to group custom dates for an evaluation metric.
Value: A range of dates in March
How many days it takes to do a given task.
For example:
I've worked on trying to group with a DAX calendar or using filtered slicers, but I would like to ask if anyone can provide a more robust solution.
Many thanks!
Just to first clarify. Is your grouping to do with the turn around time of the task itself? I.e. is it independant of the date it completes and is all about having your value fall into a group based on the End-Date minus the Start-Date?
If so, create a column which is the TurnAround Time (TAT) in days. Next create another column with a SWITCH condition that does the check of the TAT result and then records on of the string groups you had listed.
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |