Forum Discussion
Custom quarter column
Hi guys I need help with these dates, running into a hitch with the query to add a column Q1 - 11/18/2022- 2/18/2023 Q2- 2/17/2023- 5/17/2023 Q3- 5/18/2023- 8/17/2023 Q4 8/18/2023-11/17/2023 ...
= let
Date = [Date],
OffsetMonths=2,
OffsetDays=-17
in "Q"&Text.From(Date.QuarterOfYear(Date.AddDays((Date.AddMonths(Date,OffsetMonths)),OffsetDays)))