Forum Discussion
Calculate duration based on dropdown value
So I have following Table (example):
| Project | Process | Completion Date |
| 1 | A | 01.02.2022 |
| 1 | B | 07.02.2022 |
| 1 | C | 18.02.2022 |
| 1 | D | 15.03.2022 |
| 2 | A | 06.03.2022 |
| 2 | B | 20.03.2022 |
| 2 | C | 28.03.2022 |
| 2 | D | 05.04.2022 |
| ... | ... | ... |
Based on this table I want to create two dropdowns:
Process1 (=column Process)
Process2 (= column Process)
If the user now choose Process1 = A and Process2 = C the output should be the mean duration over all projects which it took for completion of Process A to Process C. The user should be able to choose between any process to see the duration. The real data consists of up to 50 processes per project and hundreds of projects.
How can I achieved this in Power BI?
1 Reply
Use two disconnected tables with the Process values and feed these to the slicers. Write a measure that reads the slicer selections and calculates your desired result.
