Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Guys ,
i have the below query setting i want only to filter (most recent date time received) the most recent datetime based a long dateformat (time included),below a screenshoot for better comprehension
Solved! Go to Solution.
Is it always going to be one file? If so, sort the column descending and use 'Keep top rows'->1
Hi @Anonymous and @HotChilli
i applied the suggestion from @HotChilli and it's working prefectly,thank you both 🙂
Hi @Wajdi ,
Not very clear about this description :based a long dateformat (time included)
Do you always want to only keep the latest received date and remove other rows? If so , please follow @HotChilli 's suggest , if not, please share more details about your expected to help us clarify your scenario.
Best Regards,
Eyelyn Qin
Is it always going to be one file? If so, sort the column descending and use 'Keep top rows'->1