Forum

Notifications
Clear all

Power Query ULTIMATE Personal Budget & Interactive Dashboard in Excel showing blanks

3 Posts
2 Users
0 Reactions
113 Views
(@bckyrdprojcts)
Posts: 3
Active Member
Topic starter
 

Hi,

Please find attached file.

 

Thanks

 
Posted : 26/03/2024 11:11 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Kagiso,

Data query combines 2 tables: Transactions and Budget. If the 2 tables don't have the same structure (headers), the table that is missing headers will have null values in those columns.

image_2024-03-29_100218739.png

The budget table has only 3 columns, no Transaction date, therefore there will be no Year/ Months for the records coming from this table:

image_2024-03-29_100555150.png

 
Posted : 30/03/2024 4:06 am
(@bckyrdprojcts)
Posts: 3
Active Member
Topic starter
 

Hi Catalin,

WOW, I was able to do the adjustments to match the two tables and I'm happy to say there are no blanks.

 

Thanks, your feedback was very helpfulSmile

 

Salute!!!

 
Posted : 30/03/2024 9:16 am
Share: