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 All, I'm working on analysis of outage reports and I have an Event query with an event ID, as well as an EventDetail query with matching ID, timestamp, type (Identified, Scheduled, Investigating, Resolved, Monitoring, Postmortem), and details. I want to add a measure/column to the Event query that determines whether the event was scheduled.
I assume this is DAX but I'm very new to it and could use a pointer on how to get a Scheduled column in Event with True/False based on whether any corresponding EventDetail rows have Scheduled in the Type column.
Solved! Go to Solution.
Create a measure
Scheduled = CONTAINS(your table,your column (e.g. type),"Scheduled")
Hi @Anonymous,
Can you share a sample?
Best Regards,
Dale
Create a measure
Scheduled = CONTAINS(your table,your column (e.g. type),"Scheduled")
Awesome, thanks!
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |