Forum

Power Query to show...
 
Notifications
Clear all

Power Query to show first Left Column

2 Posts
2 Users
0 Reactions
119 Views
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Hi

 

I have data which is updated daily. Column names are Product, Dates (added to daily) (dd/mm/yy), BLANK ..... then other columns which are removed in the Query.

I'd like the Query to show Product, a few dates which I have chosen using Choose Columns THEN I want to add the column Left of BLANK, which will change daily. Today the date of the Left column is 27/05/24, tomorrow it will be 28/05/24 ... etc.

Can this be done in Power Query?

Many thanks

Kasey

 
Posted : 29/05/2024 6:40 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Please upload a file with some (non confidential) sample data showing what you are dealing with. And include the expected result. Then we don't have to guess what you want 🙂

 
Posted : 29/05/2024 9:53 am
Share: