Calculated column challenge :)

[Anonymous]

Goodmorning.

I need this calculated column based on my calendar table. The table has fiscal- year, quarters and months columns in place and it contains future years.

I need a true/false column showing only the current and last fiscal year based on today(), BUT current fiscal year must only show true for completed fiscal quarters. So 1/10 it should state q1 and past 4 quarters as true, 1/1 q2 and past 5 quarters as true, 1/4 q3 and past 6 quarters as true etc...



The client has fiscal year 30/6.

[v-chuncz-msft]

@Anonymous 

You may take advantage of DATEDIFF.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.