We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
See how you have nested "each" ? That's asking for trouble. The Power Query engine can be confused and grab data from the wrong context. Use function notation instead.
Learn about scope - the Power Query equivalent of context. You can use function notation instead of "each" to clearly identify your context layers and address items in each.