CENSUS Power Query (and Power BI / Excel)

#1 · 2025-04-25, 6:13 am

With Power Query you can combined Census both Principal & Shared to display missing and Present census facts by Person and Year. Essentially I have 4 queries. Census Alive, Census Missing, Census Actual (Present), and Census details(Combines the there others via Append)

This is still work in progress but thought I would share what I did last nite

Uploaded files:

Tom Holden has reacted to this post.

#2 · 2025-05-03, 3:09 pm

I meant to say "Wow!" when I first saw your post a week ago. That's a bunch of queries pulled together in the one screen.

kevync has reacted to this post.

#3 · 2025-05-04, 9:09 am

THANKS!

Well -- the multipage report is more impressive. (still a work in progess)

Yes -- I might be up to 2 dozen queries plus "joins" in the datamodel.
The interactive part is what makes is really useful vs a static query

Uploaded files:

Binder1.pdf