Forum Discussion

aveluru's avatar
aveluru
New Member
10 years ago

Calculating current Quarter

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!  ...
Need Help
greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

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's avatar
deepvibha
Icon for Advocate II rankAdvocate II
9 years ago

Thanks greggyb,

 

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

 

Regards,

Deepak