Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
using PowerQuery, how would you filter dates such that only the rows corresponding to the last day of the month remain?
If I'd need to filter for the first day of the month i'd use the follow:
= Table.SelectRows(each Date.Day([Date])=1)
Can't do the same for the end of month date.
Thank you
gianmarco
Solved! Go to Solution.
Hi @gianmarco ,
The "DaysInMonth" function is handy for this requires just a small tweak to your solution. In this example my previous step is called "Previous Step".
Table.SelectRows(#"Previous Step", each Date.Day([Date]) = Date.DaysInMonth([Date]))
Hope this helps.
Hi @gianmarco ,
The "DaysInMonth" function is handy for this requires just a small tweak to your solution. In this example my previous step is called "Previous Step".
Table.SelectRows(#"Previous Step", each Date.Day([Date]) = Date.DaysInMonth([Date]))
Hope this helps.
Thank you a lot!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.