I have shown you before how to filter a table by its most recent record before, but I have found a cleaner and I think more effective way to do it. (Tests both versions to see what works with your data)
Here is the link to the previous video:
youtube.com/watch?v=hidJ5T_DYQ0
and here it is how to filter N records:
youtu.be/XShGFyxHLFw
Get download 67 from the Curbal download center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact
************
MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
- Keep most recent record on a table with Power Query | Improved solution ( Download)
- How to filter a table to show only most recent date by group in Power Query ( Download)
- Filter a table to the last N records in Power Query ( Download)
- Power BI: Remove Duplicate Records And Keep Most Recent ⚡ ( Download)
- Get MOST RECENT RECORD from a list using ONLY 2 STEPS // Beginners Guide to Power BI in 2022 ( Download)
- Lookup Most Recent Record - Power Query- Simple and Robust ( Download)
- Double The Records When I Refresh Power Query Excel.CurrentWorkbook Recursion - EMT 1624 ( Download)
- Filtering a Table to Display Most Recent Dates by Group: Power Query Tutorial ( Download)
- C3 - Importing & Cleaning Data for Better Analysis ( Download)
- Recent N Records in PowerQuery ( Download)
- Power BI PowerQuery - Get the Latest Date using List.Max ( Download)
- How to Compare the Most Recent and Penultimate Scores by Date for Each Group in Power Query ( Download)
- Get Most recent/Max Date value in PowerBI using DAX | MiTutorials ( Download)
- How to Get the Maximum Sales per Product per Latest Entry Date with Power Query Table Buffer ( Download)
- Group Uniques - Power Query Challenge ( Download)
