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 am trying to extract and search the List and Records from JSON column.
Here is my query steps so far and below is the explaination of one row
1. Here is the record for each row
2. In the each record there are few values.
3. I need to search only in the Notes. It is a 'List' .
4. In each list there are multiple records it can goup to 50.
In this example, there are 18 case notes left.
5. Here is the structure for each record. In the each record, I have to look for "Conversation with" row and need to search for a string "RTB", if 'RTB' existing then the original row it should display 1. In this example, 63207 should have 1
Can I get some guidance to proceed further pls?
I think you can add a new custom column along the lines of
if List.MatchesAny( [CaseJson][Notes], each _[ConversationWith] = "RTB") then 1 else 0 end
The syntax may not be quite right but I think the general principle will work
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 |
---|---|
107 | |
98 | |
78 | |
64 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |