Find Current Quarter

[ronaldbalza2023]

Hi everyone, I have a date table and I wanted to know how to find the current quarter based on my "quarter of the year" column? I wanted to create a calculated column that can find the current quarter of the year. Thanks and appreciate the help 🙂

[v-eqin-msft · Accepted solution]

Hi @ronaldbalza2023 ,

If you want to filter all data whose quarter is the same as current quarter(now=4), I'd suggest you create a measure:

Measure=IF(MAX('TABLE'[Quarter]) = QUARTER(TODAY()),1,0)

And then apply it to filter pane, as shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ebeery]

@ronaldbalza2023 what do you mean by "current"?  Like, today's quarter? Updated each time you refresh the dataset?

[ronaldbalza2023]

Yes, Like today's quarter. 🙂

[ebeery]

Ok, then this should work:

Today's Quarter = QUARTER(TODAY())