Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power query

Hi How can we add quarter column using date in power query not dax Any help would be appreciated Thanks in advance
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
4 years ago

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