Forum

PQ Help with Fracti...
 
Notifications
Clear all

PQ Help with Fractions

4 Posts
2 Users
0 Reactions
56 Views
(@ricafonyat)
Posts: 9
Active Member
Topic starter
 

Dear Mynda, I hope all is well with you.

I would appreciate your help with the attached spreadsheet. As you will see there are two sheets. The first with the data source and the other with the desired result. Could you give me some tips how to achieve the final result?

It is possible to do that through Power Query & M language?

Any help it will be very welcome.
Thanks a lot and Best Regards
Jose Ricardo

 
Posted : 16/03/2017 4:43 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Jose,

Yes, see attached.

You'll notice I've used lots of technqiues so you may want to review some of the Power Query course lessons.

Mynda

 
Posted : 16/03/2017 8:09 pm
(@ricafonyat)
Posts: 9
Active Member
Topic starter
 

Mynda, many many thanks for your precious help. 

Be sure that I am going to review PQ Lessons and study the beautiful code produced by you in this Fractions sheet.

Best Regards.

LaughLaughLaugh

 
Posted : 16/03/2017 9:53 pm
(@mynda)
Posts: 4761
Member Admin
 

I'm sure you can improve on the steps. 🙂

 
Posted : 17/03/2017 1:09 am
Share: