validate if metric>1 (between dates) with blend of data ((SCORE CARD))

[Dodein]

Hello everyone!

So basically I want to make a new KPI for one of my lookers and I dont know how to do it. Let's call the new KPI, "Master Active Brand", this kpi has 3 conditions: 1) Had spent something in the last 2 months (in this case the metric is called "Spent")
2)Is spending in this moment.
3)The Brand "Revenue">"Spent"

If those 3 conditions are checked, then i just need a counter. I managed to use count_distinct for a lot of new kpi based on strings (also lots and lots of regex) but I really dont know how to implement those 3 arguments in a formula. I've tried with parameter and also I tried by making a custom function in the data source so we can filter from the beggining the date. Also I want this kpi to be visualized as score card, thats why I am here! 😄

Thanks for your time! Cheers!