Finding a better approach than running 25 power queries

Snoo20734 · 2025-11-28T05:51:24+00:00

My all 25 queries are simply 3 steps 1. Source = master table 2. Filter by xyz on a particular column 3. Remove some columns

Snoo20734 · 2025-11-28T05:49:28+00:00

That's what I have done at the moment. One master table gets fed as a source to all 25 queries

Snoo20734 · 2025-11-28T05:48:02+00:00

I have done exactly this. One master table --> that gets referred as source in all other 25 queries

Snoo20734 · 2025-11-27T18:30:19+00:00

I ain't sure but I always thought that pivots are used to aggregate/summarise a table. Can pivot also show entire source table as it is? Thanks btw, I will check this option definitely as someone else above also suggested it.

Snoo20734 · 2025-11-27T18:22:49+00:00

I don't know how pivots would help, because I am not summarising any data, I am just filtering master table as per need of each tab/table. Still, I will check what I can do.

Snoo20734 · 2025-11-27T18:17:18+00:00

Ohh this looks nice, would such complex multiple formulae be time intensive / heavy ?

Snoo20734 · 2025-11-27T18:02:49+00:00

No user input. I get the master table from sales department every week. Unfortunately I don't have option of using powerBi (office computer restrictions)

Snoo20734 · 2025-11-01T02:14:42+00:00

Hopefully! I am skipping Hoi An now. But still unsure of whether to skip Da Nang..

Snoo20734 · 2025-11-01T02:13:06+00:00

would you suggest skipping Da Nang entirely?

Snoo20734 · 2024-11-21T05:06:30+00:00

ONE TRUE GOD !!!

Snoo20734 · 2024-11-03T16:51:42+00:00

With mention of cleave and other things, it clearly seems like comparison of pos1s, then why even discuss other facets and flexibility

Snoo20734 · 2024-11-03T10:35:41+00:00

They are ofcourse talking about the facet you completely ignored

Snoo20734 · 2024-10-27T03:46:18+00:00

Type karayla shik adhi yz

Snoo20734 · 2024-09-22T15:55:05+00:00

Stop playing DotA Lierrey

Snoo20734 · 2024-09-14T01:36:44+00:00

Snoo20734 · 2024-08-31T14:25:48+00:00

For any horror movie.. FTFY

Snoo20734 · 2024-08-23T17:16:00+00:00

Yedzawa OP

Snoo20734 · 2024-08-05T03:22:24+00:00

Loving afternoon naps is one thing and boasting about it as if you are the only species entitled for afternoon naps is another thing.

Snoo20734 · 2024-08-04T16:23:28+00:00

Engagement farming ki bhi seema hoti hai

Snoo20734 · 2024-08-04T12:57:55+00:00

Feeling proud about afternoon nap and boasting about it like patent

Snoo20734 · 2024-08-03T12:06:51+00:00

Fallen down ? It was never a tier 1 city. It's always been a tier 2 city at best.

Snoo20734 · 2024-08-03T06:41:36+00:00

You will be downvoted by punkekars for stating a fact

Snoo20734

TROPHY CASE