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 have a report with records as shown below.
Please suggest on how to extract this and convert into a list
My requirement is to create list for each customer.
Please help.
Thanks in Advance,
Neelofar.
Hi @Anonymous
My requirement is to show awards,4 & business,3 and so on in one row.
I could do it in a column Merged but requirement is to show merged column in a single row
do you need, by any chance, the Table.ExpandRecordColumn function?
To extract values contained in a record into a list, use below formula
= Record.ToList([Field Name])
Replace Field Name appropriately. Hence, for given example, it would be
=Record.ToList([SECTION.secondary_section])
Not sure what you want. Your second screenshot doesn't show a list; rather it shows an expanded record. And I don't see any customer name or ID that you could use to tie that record to a customer.
Please clarify what you want.
Hi @ronrsnfld ,
My table look like
I need help to turn each sections into ordered list for each ssor_id.
The seconf screenshot i mentioned earlier is what i am getting when I click on 1st section column.
The section column was initially like below
{
"secondary_section": {
"awards": 4,
"business": 3,
"chargers": 1,
"climate & environment": 2,
"company town": 1,
"dodgers": 1,
"entertainment & arts": 3,
"food": 1,
"latino life": 4,
"politics": 3,
"rams": 1,
"science": 1,
"sports": 1,
"television": 1,
"world & nation": 9
},
"section": {
"business": 5,
"california": 19,
"entertainment-arts": 1,
"entertainment-arts:movies": 6,
"entertainment-arts:music": 2,
"lifestyle": 2,
"opinion": 3,
"politics": 5,
"science": 3,
"sports": 2,
"sports:angels": 1,
"sports:dodgers": 6,
"sports:soccer": 1,
"world-nation": 16
},
"top_section": {
"business": 5,
"california": 19,
"entertainment-arts": 9,
"lifestyle": 2,
"opinion": 3,
"politics": 5,
"science": 3,
"sports": 10,
"world-nation": 16
}
}
Now I want the 3 columns "secondary_section","section","top_section" to be shown in list rather than showing like Record.
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |