All posts

Tag

#power-query

2 posts tagged with “power-query”.

Stylised illustration of a tea stall with two oversized props dominating the frame. On the left, three sheets labelled JAN, FEB and MAR are skewered one above the other on a tall metal receipt spike, a downward arrow beside them and a label reading 1,248 rows by 6 columns, taller. On the right, two sheets sit edge to edge joined at the seam by a long-arm stapler, the left sheet labelled SALES and the right labelled PRODUCTS, with a label reading 1,248 rows by 8 columns, wider. Reena stands small in the centre behind her counter looking between the two. A hanging sign above her reads HOME, COMBINE.

Analytics

Merge and Append Walk Into a Tea Stall

Reena has three monthly sales files and a product lookup table. Her cousin wants one dashboard by Sunday. The Power Query ribbon offers two buttons side by side, and picking the wrong one either loses her February or silently doubles her revenue.

Rani C 12 min read
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.

Rani C 11 min read

Stay in the loop

Follow Yuvijen on LinkedIn.

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

Follow on LinkedIn

linkedin.com/company/yuvijen · no signup needed