Tag

#power-query

1 post tagged with "power-query".

Stylised illustration of a tea stall — Reena stands centre behind her counter looking up at a chalked flowchart on the back wall titled `TWO WAYS TO COPY A QUERY`. The flowchart shows an ORIGINAL chain of three step-boxes (Source, Cleaned, Output), a DUPLICATE chain below it that copies all three boxes identically in plum, and a single REFERENCE box on the right that says `= "Original"` with a curved live-link arrow pointing back up to the ORIGINAL's Output. On the far left a woman in plum holds a thick photocopied folder labelled `ALL STEPS`. On the far right a woman in soft grey holds a small slip with a curved string trailing offstage.

Analytics

Duplicate and Reference Walk Into a Tea Stall

Reena needs two new summary tables off her cleaned sales query. Power BI offers two options that look identical on the right-click menu — and her cousin warns that one of them will quietly break tomorrow.

07 May 2026 Rani C 11 min read

Stay in the loop

Connect with Dr. C. Rani on LinkedIn.

New posts, research notes, and HR-analytics tips — straight to your LinkedIn feed.

Connect on LinkedIn