Latest Date in Custom Column  [Solved]

Post Reply
jrpol
Posts: 5
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 49 times
Top
MattAllington
Posts: 1053
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
Top
jrpol
Posts: 5
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,
Top
jrpol
Posts: 5
Joined: Wed Jul 11, 2018 9:09 pm

Re: Latest Date in Custom Column

Postby jrpol » Wed Dec 05, 2018 8:54 pm

Thanks!!!
Top
Post Reply

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests