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

1 Reply

  • 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