Re: Calculating current Quarter

aveluru · ‎01-26-2016

Hi Experts,

I have a Fiscal Year/ Period column using which I have defined Fiscal Quarters. Is there way/ formula to know the on going fiscal quarter.

Quick response is highly appreciated!

Regards,

Ashok

Greg_Deckler · ‎01-26-2016

You could create a calculated column, = TODAY() and relate that to a date table with dates and associated fiscal quarter.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

greggyb · ‎01-26-2016

Assuming your date dimension has a field containing calendar dates:

Current Fiscal Quarter =
LOOKUPVALUE(
    DimDate[Fiscal Quarter]
    ,DimDate[Date]
    ,TODAY()
)

You can then use this anywhere you need to return the current fiscal quarter. This is unaffected by filter or row context.

deepvibha · ‎12-02-2016

I could resolve many "current"s like Fiscal Year, Fiscal Quarter, Week etc.

Regards,

Deepak

Calculating current Quarter