Forum Discussion
Common Math problem: for calculating Fiscal Quarter Offset
I need help to use a M formula to calculate [Fiscal Qtr Offset], based on [Fiscal Mth]. Would really appreciate if you can help! Fiscal year Fiscal Mth Fiscal Qtr Offset F2019 1 -5 ...
Thanks for the suggestion v-frfei-msft
I have a much larger date table generated using PQ, so I was hoping to look for a PQ solution.
I was able to solve the issue - hope this will help others in the future:
= Number.RoundDown(((Date.Year([Date]) - Date.Year(CurrentDate)) * 12 + Date.Month([Date]) - Date.Month(CurrentDate)) / 3, 0)
Anonymous
Need little more explanation on how you are generating Fiscal Qtr Offset? The Current quarter will always be -1?