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!
Proud to be a Super User!
Assuming your date dimension has a field containing calendar dates:
Current Fiscal Quarter =
You can then use this anywhere you need to return the current fiscal quarter. This is unaffected by filter or row context.
I could resolve many "current"s like Fiscal Year, Fiscal Quarter, Week etc.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.