Forum Discussion
Taking 'First' from unpacked json object
I have a MongoDB data, and there is a delivery address json:
{
total order details: such as amount, order number etc
delivery address object:{
first name
last name
some other fields
delivery country
}
}
I dont want to unpack this object because this will duplicate my numbers at a total level, I only want to take a first observation of delivery country per order.
How can I do that?
1 Reply
Try it out. Have Power BI connect to the list of items, then use List.First and check if the query still folds.
