Column with flag if customer reached certain Value

[Gionedis]

Hello,

i need two calculated columns with flags if the customer reached:

Over 30 days in overdue in 6 months on book (MOB)

Over 90 days in overdue in 12 months on book (MOB).

The data:

In the example, this contract reached 35 on MOB 5, so the flag_6mob_ever30 is 1, but on the 12 MOB, he never reached 90 since the beginning, so the flag_12mob_ever90 is 0.

Thanks in advance.

[PurpleGate · Accepted solution]

Something like this?

FLAG_6MOB = IF('Table'[OVERDUE]>30,1,0)

 fLAG_12MOB = IF('Table'[OVERDUE] > 90, 1, 0)

To make the physical flags:

Column = 'Table'[fLAG_12MOB]+'Table'[FLAG_6MOB]