Главная

Keep most recent record on a table with Power Query | Improved solution

Кадры Keep most recent record on a table with Power Query | Improved solution

Описание Keep most recent record on a table with Power Query | Improved solution

Коментарии Keep most recent record on a table with Power Query | Improved solution

Thank you so much, this is really going to help 👍🏽👍🏽👍🏽 Comment from : @balrajvirdee1087

Thank you! You saved me! Comment from : @shaygooding

came back to re-watch can confirm this is a very legit solution extra credit for being so simple and short! Comment from : @30redpillsaday71

Thank you very much Extremely helpful for me! Brilliant Comment from : @evanlouden2623

amazing! Comment from : @30redpillsaday71

Thank you very very much! I really appreciate it! Comment from : @lancesmith1078

wow, save my life!!!brbrtks, Brazil appreciated Comment from : @lucasmendoncaoficial

It works wonderful, thank you so much for that best practice! Comment from : @FranceLesEnfoires

That logic is so simple yet brilliant Comment from : @theenlightened1s

I do not have the same table, but in concept it looks the same Doing the group-by shows the same results The only thinig I would like to have is the last record per month brIs there a easy way to do this? Comment from : @rikbrand6789

Question: I have a dataset with candidates activity I grouped the data using candidate ID column brI definitely only want to see their most recent activity on a requisition but if they applied to more than one req, I want to see their latest activity on all those reqs and not just the latest activity, how do I achieve that Just for context, there's req ID column as well to identify different requisitions Comment from : @YTWhisperer

Hi Ruth, This solved one of my problem My other problem is I need as well to have the 2nd to the latest date How to do this? Thanks in advance Comment from : @markphillipcastillo9404

awesome thanks for this video Comment from : @Rollenced

I'd totally hit that "Like" button 10 million times if I could! Thanks a million, you're a real lifesaver! 🚀 Comment from : @YTWhisperer

Hi Ruth, thank you yet again for a brilliant video! Do you know why all the columns you expand gets the mixed data type? And is it possible to maintain the data types from before you pick the max value after you have expanded the records? Thanks in advance! Comment from : @magnusvangekjrchristensen1996

What if we have date time column Comment from : @dilchahtahai4456

It worked very well thanks Comment from : @kuemcheonbae5231

Awesome solution Thanks for sharing Comment from : @TheZugo24

This was exactly what I needed, I found this after spending almost a week to figure it out! Thank you so much Comment from : @mariannna3

Thank you!! Comment from : @anitashoo

Hi Ruth, Great Method just removed the default column name prefix and it worked like gem Comment from : @Anand698

This works fine, awesome thanks for the help Comment from : @hannsflip

This just saved an incredible about of staff time across numerous departments Thank you! I'm going to be a considered a hero because of you! Comment from : @lacey1755

Fabulous!! Thank you Comment from : @rustytoyn113

Nice Trick, Thanks a lot Comment from : @asees555

Awesome Thank you! Comment from : @mitjakatavic2095

Bedankt Comment from : @KrisDetaevernier

I loved the method, how could I make it show the most recent record but by month? I hope you can see it, thank you Comment from : @Gabyneji

Awesome Comment from : @shubhabratadey

Hi this was really useful Thanks a lot for sharing Comment from : @serigamel

please what if i need last 2 records? Comment from : @Immortal34345

Thank you! This video is excellent as previous! Comment from : @user-qy1ck1cl8n

Brilliant as always Comment from : @magnusvangekjrchristensen1996

Instead of get the latest, can we add new column and have Latest and Superseded😁 to still get all the records Comment from : @mielkew27

Incredible, worked the first time! Your videos are so easy to follow! I'm also hoping for a solution to keep the 2 most recent records Any help would be greatly appreciated! Comment from : @charlielow79

Oh my goodness, I am so happy I have found your channel I have just recently started working in Power BI and your solutions are so helpful Thank you again Comment from : @leebaldwin9198

This is a great quick and easy solution Is it possible to find the max on multiple columns, like date and number? Comment from : @nmhuis

Amazing solution Worked perfectly well and its efficient too at least in my case THANKS A TON 🙂🙂 Comment from : @santoshsahoo_destiny

Amazing! That was exactly what I have been trying to accomplish for two hours now If only I had found your videos two hours ago :D brThanks a lot! Comment from : @herrsan

Awesome explanation - thank you so much for the video! Comment from : @marcinczajkowski5831

Every time that i have a doubt i search in all internet, and i end in your videos with the solution thanks for all Comment from : @willianranzani1223

Awesome, Curbal Comment from : @jeffweir9358

You deserve an award for this help Comment from : @HunainSami

thank you vry much! Comment from : @descubriendopowerbi7899

My god it worked the first time I tried it! You are indeed a world treasure for us data nerds Comment from : @seang2012

THANK YOU! This was exactly the solution I was looking for, and I've been searching without luck for a while This was explained so well I also learned something from the previous video Cheers! Comment from : @mattniccolls7833

You are really a genius! I was struggling a lot finally I got your video and you resolved my problem Thank you so much for uploading this video Comment from : @PradeepKumar-wh1pf

🎉🎉 thanks a lot Comment from : @topetealan

You saved my life 😘 Comment from : @VoandoAltoSP

Thank you so much! Have been looking for a solution to this problem for weeks!!!! Thank you!! Comment from : @JBJ3714

That solved my problem thank you Ruth you re a star!!! Comment from : @dimitrykotchkareff8760

This has worked SO well in multiple situations!!! Thank you so much! We appreciate you! Comment from : @CAKimberlyLewis

This is absolutely awesome Everytime I have PowerBI problem - you seem to have the library of all solutions! brYou are definitely appreciated - as always, love how you make seems everything easy for us -- the PowerBI community :) Comment from : @AlvinRyellPrada

Awesome! Very clear and quick explanation! Thanks! Comment from : @gustavoquege6757

This is such a great video, I have used this action multiple times now It works like a charm and is so straight forward Comment from : @lepettit

Thank you for this I used the old method and this one is much easier It works for my needs Comment from : @DarrylBodkin

Hi, how can I execute the same query if there's no date column in the given table Kindly advise, thank you Comment from : @bhargavtadepalli9550

Excellent tip !!! Many thanks Comment from : @bitips

Thank you so much for your help, i was trying to solve such problem for more than 3 hours than i watched this video and just solved itbrbrRegards from brazil Comment from : @Silverbolt90

OMG thank you, I searched half the internet for a solution and most of them were inapproriately complex and based on DAX language Comment from : @edinceman1574

You made my day mam Thank you for the valuable content and for being straight to the point Comment from : @aakuthotaharibabu8244

Thank you for this information My data is definitely trimming down, but I'm still getting multiple lines for some of the grouped values What causes that? Comment from : @lepettit

This is so useful! brI have a fact table that is upwards of 10m rows and growing - I'm able to use this method, but it takes forever to load and is timing out in dataflow brAny tips on using this over very large tables? brAlso, is it possible to this step to maintain query folding? brThanks! Comment from : @kim1217

Brilliant, Just helped me solve a real headache, Thank you Comment from : @andrewboxall7930

Thank you so much! This is exactly what I needed :) :) Comment from : @quotemonster2393

If i want to extract first record, is there tablemin function?? Comment from : @SamehRSameh

Hi thank you for this method! i tried aplying it but was told it is not compatible with directQuery is there an alternative method? Comment from : @mayers33

Is it possible to achive similar result using DAX?brTo get a value of a max date Comment from : @Mountainboarderr

Just great Thanks! Comment from : @hagaimichaelis7787

Thank you so much! This is very helpful! I tried this on the dataset from an hour and it worked, but I have years worth of data! it is extremely slow and going on for days :((( any suggestions for a big dataset please?? I cannot get my work done :((( Comment from : @Nonameviewer

Hi, I used two columns to “group by” and it seems to have worked perfectly! However, when i expand my records, all the column names are now prefixed with “Count” For example: CountFirst Name Can you tell me what I did wrong or how to fix this? Thank you!! Comment from : @cynthias1120

Hi, thank you for your help! brbrI have a question:brMy data set is very similar to yours, but have some blanks in it So, if I use maximum(date) than I can actually retrieve a blank value, which I don't want to So what extra step should I do to retrieve the latest date with a value (the latest known information) in this situation ? Comment from : @voxgun

Awesome awesome awesome brThis is super cool method, helps me in my project Comment from : @sahilmehta9881

both are great solutions, thank you! are they sensitive to date filter though? supose I'm using a date filter on dashboard, does the most recent record changes as the date filter changes? Comment from : @rodrigomachado3678

thank you, ruth! you're magical Comment from : @biancamichelschaves3117

Hi Ruth! Love this shorter method I tried this method and instead of getting "Table" in the rows of the grouped column, I got "Record" in each row However, expanding the "Record" column gave the filtered rows of the Max Date Comment from : @denholmkendall1010

Today I was asked to do this, I checked your channel and just like ordered you got it! Comment from : @Sandroider

Excelente Ruth, una magia pura hacer ello Comment from : @andresespinoza6370

Sort by date column(wrap this statement w/ TableBuffer), right click ID and "remove duplicates" Easiest/efficient way I've found so far, and we've played with this a lot ListMax/TableMax/Group_By etc Comment from : @davidlopez-fe2lb

What a coincidence, I just watched and used the method in the older video You have saved me yet again Comment from : @New2you09

Nice, I will be using that tomrrow!! Comment from : @gordsimpson8916

What does the underscore do? Comment from : @anthonjhnon1

This is cool However there is problemHow do you solve this difficult challenge you have null values in your dataset n each null values are data to be filled because they are coming from the web in real-timebrThe dataset has non collapsible rows,so that every records n unique ids are separated individually, with null values in each rowsbrGroupby will ignore the null values , n how can one prevent this null values missing,otherwise the column or columns when updated will be missingbrThank you Comment from : @valentineonuchukwu9694

Thi is so cool I faced a similar problem recently Thank you! Comment from : @akakakakak3047

Magnifico Profe, Le cuento que el anterior me ayudo muchísimo Muchas Gracias Comment from : @RoyerNadian1

great idea Comment from : @mcnater

et voila 👍💥 Comment from : @spen2431

Nice! I shared on LinkedIn too! Comment from : @tomr9969

Thanks for sharing this logic Ruth ! You are amazing:) Comment from : @abhishekstatus_7

Похожие на Keep most recent record on a table with Power Query | Improved solution видео

SQL Server Performance issues || SQL Server Long Running Query || SQL Server Query Running Slow РѕС‚ : Tech and Art Download Full Episodes | The Most Watched videos of all time

How to Troubleshoot a Slow Running Query in SQL Server Azure SQL|Query Tuning|SQL Server Wait Stat РѕС‚ : DataDrivenCommunity Download Full Episodes | The Most Watched videos of all time

How to optimize SQL Queries | SQL Query tune | how to speed up sql query РѕС‚ : learnprograming byluckysir Download Full Episodes | The Most Watched videos of all time

complete care of table kamini plant || how to get more growth on table kamini РѕС‚ : gardening with chinu minu Download Full Episodes | The Most Watched videos of all time

Introduction to T Flip Flop | Circuit, Working, Truth Table, Characteristics u0026 Excitation Table РѕС‚ : Gate Smashers Download Full Episodes | The Most Watched videos of all time

How to grow u0026 care table kamini plant Hindi || Table kamini plant care and cutting propagation РѕС‚ : Sujeet gardening Tips Download Full Episodes | The Most Watched videos of all time

Table Kamini Care and Best soilmix | Table kamini bonsai РѕС‚ : Techn Garden Download Full Episodes | The Most Watched videos of all time

most recent playboi carti snippets june 2020 (WLR??) РѕС‚ : reaperrr Download Full Episodes | The Most Watched videos of all time

7 Most Improved Games for PS5 u0026 Xbox Series X (Star Wars, Destiny 2, Ghost) - Performance Review РѕС‚ : IGN Download Full Episodes | The Most Watched videos of all time

Learn Power Query u0026 Automate Boring Data Tasks in 15 Minutes! РѕС‚ : Chandoo Download Full Episodes | The Most Watched videos of all time