Latest Date in Custom Column

jrpol
Posts: 4
Joined: Wed Jul 11, 2018 9:09 pm

Latest Date in Custom Column

Postby jrpol » Sat Nov 03, 2018 4:34 pm

Hi every one!
I need to identify the row with the current payment received for the specific payment reference by adding a custom column in power query.
I know that this can be done through DAX, but I much prefer this added column before loading it to the data model.

Many thanks in advance!
Attachments
sample2.xlsx
(8.49 KiB) Downloaded 6 times

MattAllington
Posts: 999
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Latest Date in Custom Column

Postby MattAllington » Sun Nov 04, 2018 6:29 am

What is the logic that needs to be applied to get your desired output?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

jrpol
Posts: 4
Joined: Wed Jul 11, 2018 9:09 pm

Re: Latest Date in Custom Column

Postby jrpol » Mon Nov 12, 2018 9:38 pm

Hi MAtt!

I need to identify the rows with the latest payment date for the same PAYMENT_REF.
Hope this helps.

Regards,


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests