Need to build check basis quarter

Question

I have the below data for which I need to check Flag for 1 if have received data for complete Quarter else 0. for eg. in the below mentioned table, I have received data till May which is Q2 and I'm still expecting data for 1 month in Q2 so my flag will be 1 for Q1 only and in July when i get Jun data complete Q2 will be flagged as 1. Please help

Status  May

FlagMonthMonth_NoQtr1Jan1Q11Feb2Q11Mar3Q10Apr4Q20May5Q20Jun6Q20Jul7Q30Aug8Q30Sep9Q30Oct10Q40Nov11Q40Dec12Q4

Status in Jun

FlagMonthMonth_NoQtr1Jan1Q11Feb2Q11Mar3Q11Apr4Q21May5Q21Jun6Q20Jul7Q30Aug8Q30Sep9Q30Oct10Q40Nov11Q40Dec12Q4

Thableaus · Accepted Answer

Hi @SamSurya

How do you know you have received data from a specific month? Is this based on current date? Like, by July 1st, will you have received data from June already?

Cheers,

Thableaus · Accepted Answer

@SamSurya

Would something like this work?

Cheers,