The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a dataset with dates for each day of a given period. I'm trying to filter and only keep rows where the event date = the last date of the given month.
How do I perform that in PowerQuery (Doing it in DAX after data is loaded is not an option)?
Solved! Go to Solution.
You can use the GUI function in the columns tab, under Date, to add and End of the Month column, then use
Table.SelectRows(PriorStep, each [Date] = [EndOfMonth])
--Nate
You can use the GUI function in the columns tab, under Date, to add and End of the Month column, then use
Table.SelectRows(PriorStep, each [Date] = [EndOfMonth])
--Nate