Hi @ImkeF! Awesome! Thx for your Example and explanations from you.
I have a last question about it. You use Json.Document instead of Excel.CurrentWorkbook, result of making the query from table into Excel. What is the advantage of use Json?
Sorry, should have said this: The Source-expression using JSON should be replaced by the reference to your table.
(I just used it to "ship" sample data with so that you can just copy/paste the code into the advanced editor and see the results.)
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Great @ImkeF! all clear now. Thx for your support. Blessings!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!