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
Quarter =
let
Date = [Date],
Q1Start = #date(2022, 11, 18),
Q2Start = #date(2023, 2, 18),
Q3Start = #date(2023, 5, 18),
Q4Start = #date(2023, 8, 18)
in
if Date >= Q1Start and Date < Q2Start then "Q1"
else if Date >= Q2Start and Date < Q3Start then "Q2"
else if Date >= Q3Start and Date < Q4Start then "Q3"
else "Q4"
Getting errors.
Thanks for your help!
3 Replies
= let
Date = [Date],
OffsetMonths=2,
OffsetDays=-17
in "Q"&Text.From(Date.QuarterOfYear(Date.AddDays((Date.AddMonths(Date,OffsetMonths)),OffsetDays)))Thanks guys, I think it had to do with how I wrote the code. I just copied and pasted and it worked.
