Power query

[Anonymous]

Hi

How can we add quarter column using date in power query not dax

Any help would be appreciated

Thanks in advance

[BA_Pete · Accepted solution]

Hi @Anonymous ,

To get calendar quarters you can just use:

Date.QuarterOfYear([Date])

To get financial quarters, you will first need to define your financial periods as period numbers against each date. Then you can use the following referencing the financial period:

Table.AddColumn(previousStep, "finQtr", each
if [finPeriod] >= 1 and [finPeriod] <= 3 then "Q1"
else if [finPeriod] >= 4 and [finPeriod] <= 6 then "Q2"
else if [finPeriod] >= 7 and [finPeriod] <= 9 then "Q3"
else "Q4"),

Pete