You can create the following calculated fields which can assist you in your boolean value calculation
Extracting Year-Quarter from your dashboard from FY18Q4 format to 184 so that it can be computable.
Calculating max quarter for latest/current quarter
Calculating allowable previous quarters suing the Year Quarter filed created
Boolean condition for Current and Previous Quarter
Attaching the workbook for reference
test - updated.twbx 16.5 KB
Thanks a lot for your reply, it really helps me a lot. Can you also help me to understand how can I create calculations to identify other quarters like 3 quarters before my current quarter with the dataset i have? Thanks !!