Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm not sure what the best method of solving my need here is, hence my question.
I have a table with events for cases, so each case can have multiple rows, depending on the events that happen.
I'm trying to find a way where I can catch the cases which don't have one or two specific event codes, and where the "case closed" date column is not blank (meaning case closed)
I've tried making a calculated column but I'm not getting the desired results.
The result I want is the column to tell me if the case meets the above requirements or not.
For example: a "true" if a specific case nr doesn't have one or the other of the event codes, and the date column not blank. Meaning all rows for the case nr should have this true or false
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |