วีดีโอ

Group by with aggregate Max on Date?

youtube.com/@luckylovelymedia9862?si=MG9W1NoZEWmG2X33

Thanks, your video helped me alot.

Can you also show how you did with the colour settings? Thank you :)

3 years later and I still reference this video from time to time. So much that I actually bookmarked it.

Worked for me thanks a lot ❤

I used "table.buffer" in the same way but when i wanted to apply changes and close the transform data section, it takes like forever. I tried to do it for days but i gave up. There must be a problem :( Does anyone have an idea about that?

Thanks! I thought PQ was lying to me :)

saving lives here!!!

Super useful trick! You just solved my 1 hour frustration of the day with Power BI. Thanks 🙌🏻🙌🏻

2024 and you're still saving lives, google and the Microsoft forums only conjured up convoluted solutions. Thanks!

That's nice and all but I have a similar problem which I can solve in pandas but not in power BI. Suppose I have 2 tables A and B, B being the newest. I append these tables and in case there are duplicate e-mails/primary keys I want to keep only the records coming from table B which are supposedly the latest. There is no date column to take advantage of sorting gimmicks. How would you solve that? For example in pandas there is a first and last attribute that can solve this.

Very cool. Is this solution scalable to large datasets? 500K or 1M rows, for example. Just wondering if the Power BI cloud service will get angry when doing nightly refreshes with buffering enterprise scale datasets.

Is it possible to export the personalized visuals to Excel?

Thank you!

Thank you soo much

Hey man, you saved me! Thanks!

thanks for the video, learned something new today.

Great tip!

Great tip for avoiding delegation issues. Thanks!

When people use a Donut chart it by default show both a value and the percentage. Let's say they are showing total sales per. country in the donut chart. How can users change to only show the percentage per country and not both the percentage and the value for each country?

Great video 😊

thank you! your saved my mental healthy

This is great information. Is there a way to get the most recent as you show but also create a new column with data from a cell of the duplicate being removed?

That is great! But, what if you have two different tables with two different latest date of different activities that you want to get the latest activity status date. How do you solve for it?

I am trying to build a flow based on this example. However, I do not seem to have any CDS connectors. How can I access CDS connectors or is there an alternative connector I can use?

Just back here to say that this is the most perfect answer to this question

This was amazing,,,, And crazy simple as well. Thank you.

the buffer detail was to step I need, thank you very much!

thankyou very much

Thank you SO MUCH. Saved me a lot of time!

You are an AMAZING person! You have saved me at least 2 days of stress, headaches, work, and have provided the company with potentially hundreds of thousands of dollars of owed back pay as I am dealing with 190k lines of transaction records.

Table.Sort is wrapped in Table.Buffer 5:39

What if you need to use a date slicer to filter it!? How can I indicate that the relation will be based on one specific date column!?

I LOVE YOU!!! It was killing me why it wouldn't remove my duplicates and keep the latst!!

how do I undo the removal up dulicate rows/columns?

This problem was driving me nuts so great to come across this solution. Thank you very much

This video was extremely helpful and solved a big issue I was having with my SharePoint list choice column that would not filter. You saved me and I was able to hit my deadline for an app I had to deliver.

I just bumped into your vid and found the answer (not only the solution but also the reasoning behind it) to what was happening to my data. And now i can finally get some sleep haha. Thanks a lot, you're the best!

Great video, thanks for sharing!

This was brilliant. i just tried it, and it seems to be working. I will know more as i audit my data.

Always great❤❤

My Bookmark, Equivalent of SQL Partition by Row_Number() order by- 4:40 onwards

Hello there, Useful video Has the second video on this topic ever been posted ? can't find it :(

Any chance you can use text color to filter/sort?

Wow, I cannot tell you how much this speeded up what i was working on.

Thanks for making this great video. I have made a whole app using custom fields without forms. Have you made a video on how to edit data and save changes i sharepoint? Or can you explain how I do that? Cant find that info anywhere. thanks for your help. BR Sara

It’s obvious that you’re a great teacher because your videos are to the point and easy to follow! Thanks for providing these videos, great job!

Thank you so much. You have been a saviour. None other video explained the sorting action in detail. This helped to solve big bug.

I was making the exact same mistakes you were making, and you saved me a lot of frustration. Thank you!!! Subscribed!