Relative date / today in Power Query IF / conditional column
Power Query's conditional columns are super easy but they cannot work with comparing relative dates, you need custom code for that, but once you understand it there are dozens of date functions in Power Query. Remember to Wrap Date.From() around our functions to explicitly set the date format and always use upper case. If you want a copy of this workbook, leave me a comment & subscribe to my channel.
Learn all date functions here: https://docs.microsoft.com/en-us/powerquery-m/date-endofmonth
Functions I showcase:
Today: Date.From(DateTime.LocalNow())
One quarter ago: Date.From(Date.AddQuarters(DateTime.LocalNow(),-1))
End of last month: Date.From(Date.EndOfMonth(DateTime.LocalNow()))
00:00 - Introduction
02:43 - Before today
05:55 - Before one quarter ago
08:44 - End of last month
10:38 - Filtering based on a relative date
11:54 - Date functions documentation
Видео Relative date / today in Power Query IF / conditional column канала David Benaim
Learn all date functions here: https://docs.microsoft.com/en-us/powerquery-m/date-endofmonth
Functions I showcase:
Today: Date.From(DateTime.LocalNow())
One quarter ago: Date.From(Date.AddQuarters(DateTime.LocalNow(),-1))
End of last month: Date.From(Date.EndOfMonth(DateTime.LocalNow()))
00:00 - Introduction
02:43 - Before today
05:55 - Before one quarter ago
08:44 - End of last month
10:38 - Filtering based on a relative date
11:54 - Date functions documentation
Видео Relative date / today in Power Query IF / conditional column канала David Benaim
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Look up geo stats & map it on ExcelDetect existing Excel errors with data validation layeringExcel's Pareto chart & its unexpected benefitsUnpivot in Google Sheets with FLATTEN: Column pairs, auto expand++Stacked infographics in Excel & PowerPointReorder overlapping line charts in Power BI (New 2021)PowerPoint hybrid shortcuts & duplicate trickExcel copilot vs similar features (free or cheap)Advanced Sorting in Excel: Multi level, horizontal, with formulaDynamic Arrays 5 best & 5 worst features for ExcelFix cASiNg extra spaces & similar text NEW in #Excel onlineNew Excel Navigation Pane + 26 Navigation tricksExcel vs G sheets for remote working webinarExcel hash: LAMBDA, EVEN, power query, & “actors” in a murder mysteryFixing DAX issues with wrapper functions30+ formula & # format shortcuts touring Cambodia with Fred Le GuenFill formulas but keep formats #Excel #excelshortcuts #excelformula #tutorial17 Smart / AI tools in CanvaExcel must know image tricksSparklines: In cells charts in Google SheetsPQ Choose folderpath from Excel