Date Group Bin by Quarters

Power Query
1

Hi all,

I created a quarter bin for my dates but I want it to reflect as “yyyy-qq” rather than “yyyy-mm”. Is there a way for me to achieve in PQ? Screenshot of date table below. I searched online but couldn’t find the appropriate solution.

Thanks for your help.

image
image830×148 10.3 KB

2

Hi @ysherriff,

Give this a go. Go to “Add Column” / “Custom Column” and paste this into the dialog box.

Text.From([Year]) & "-" & Text.From([Quarter Number])

I hope this is helpful

3

Thanks Melissa. How do you convert to Date format? IT is currently number. When I click to convert to date format, it bring me back to the full date. I am looking for “yyyy-qq” to be formatted as date.

image

4

Based on the Date field you can go to Add Column / Date / Quarter and add a ‘date’ for the start- or end of a quarter that will be a date. This “yyyy-qq” can never be a date, only a string.

1 Like
5

Thanks Melissa