Determine whether any of the detail rows for an event contain a certain word in a specific column

[Anonymous]

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.

[v-jiascu-msft]

Hi @Anonymous,

Can you share a sample?

Best Regards,

Dale

[zenmemo · Accepted solution]

Create a measure

Scheduled = CONTAINS(your table,your column (e.g. type),"Scheduled")

[Anonymous]

Awesome, thanks!