Transform DATA

[santoshreddyk95]

Hi All, 

Below is the problem statement. Need help with this. 

I have a a data set with One of the rows containg Date. I want to import the data which has only the latest date. New rows with latest date keep getting added everyday. 
Whenever the Dahsboard refreshes, I want the data which has the latest date (only one date). That date is not necessarily yesterday, it could be anything but has to be the latest date. 

Can someone help me build this logic?

regards,

Santosh

[amitchandak · Accepted solution]

@santoshreddyk95 , refer if this can help

https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/