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.
I'm trying to collect or summarize the status of tasks based on a person, but each task is a separate row.
Here is an example of data:
Name | Task Name | Status |
Bob Smith | Task 1 | Completed |
Bob Smith | Task 2 | Pending |
Jane Doe | Task 1 | Pending |
John Jones | Task 1 | Completed |
John Jones | Task 2 | Completed |
What I would like is a formula that says - For [Name], if any Task is Pending, then "Task Name", otherwise "Complete"
So, my desired results would look like this:
Bob Smith | "Task 2"
Jane Doe | "Task 1"
John Jones | "Complete"
Any examples or tutorial references would be appreciated.
pls try this
Measure 1 =
COALESCE(
CALCULATE(MAX('Table'[Task Name]),
CONTAINSSTRING("Pending",'Table'[Status])),"Completed")
------- or-----------
Measure 2 =
CALCULATE(SELECTEDVALUE('Table'[TaskName],"Completed"),
CONTAINSSTRING("Pending",'Table'[Status]))
Hi,
This measure works
Measure = COALESCE(minx(FILTER(SUMMARIZE(VALUES(Data[Task Name]),Data[Task Name],"ABCD",MAX(Data[Status])),[ABCD]="Pending"),Data[Task Name]),"Complete")
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |