Some FP&A models claim to be “dynamic.” Until someone asks a simple question: “Can you show this using actuals instead of forecast?” Suddenly you’re duplicating queries, rebuilding pivots, or ...
This will be my first article involving Power Query, and I have chosen the topic concerning the difference between Reference and Duplicate queries. Knowing the difference between the two and where and ...