Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
How can we add quarter column using date in power query not dax
Any help would be appreciated
Thanks in advance
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |