Forum

Formula or power qu...
 
Notifications
Clear all

[Solved] Formula or power query

5 Posts
2 Users
0 Reactions
328 Views
(@orhan_oz)
Posts: 3
Active Member
Topic starter
 

Dear Sir or Madam,

Could you please help me image questions? I tried formula but I did not get result.

Thank you so much.

I would appreciate your support.

Best Regards,

Orhan

image

 

 
Posted : 25/01/2025 10:02 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

Please upload the file shown in the picture. Then we don't have to recreate your scenario from scratch.

 
Posted : 25/01/2025 3:53 pm
(@orhan_oz)
Posts: 3
Active Member
Topic starter
 

@riny 

Dear Riny,

Thank you so much for your responses

Best Regards,

Orhan

 

 

 
Posted : 26/01/2025 7:17 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

I believe the attached file contains a working PQ solution. It's not very fancy but it does the job. A number of custom columns that pick-up the correct "cells" from the table and then clean it all up with filling up/down and filter. All done by clicking in the user interface.

If you are somewhat familiar with PQ, you should be able to follow it. If not, come back here.

 

 
Posted : 26/01/2025 4:53 pm
(@orhan_oz)
Posts: 3
Active Member
Topic starter
 

@riny 

Dear Riny,

Thank you so much for your help. I really appreciate it.

Best Regards,

Orhan 

 
Posted : 27/01/2025 3:10 am
Share: