Forum Discussion
GROUPBY with Filter
Hi all, I hope that you can help me with my Power BI problem. This is my first post, so hopefully I'm doing everything right. Unfortunately I cannot upload my sample data into a cloud at work. ...
Thanks abusen333 and amitchandak for you answers! I think it is not exactly what I am looking for.
What I want: Aggregated data per test person for the selected quarters. One test person is identified by ID, Group1 and Group2 (and in the real data about five more groups). The test person is tested in one or more quarters. I need aggregated information about the test person for the selected quarters, for example the maximum of "Result" to get
- "0" if "Result" is "0" in all selected quarters
- "1" if "Result" is "1" in at least one of the selected quarter
Then I could create another column, which would be for example "passed" if max_Result = 1, "not passed" if max_Result = 0.
The same I need for other columns aswell (not in the example).