Checking values for each day measure

[Anonymous]

Hi, 

I have a table which have values like this. 



So basically I want. Column A can either be 1 or 0 through a day. Which is colum B. 

So if cloumn C has 6 = 1 values and 0 = 1 on example 10 april = Will the out be 0. 

So if one values for a day is 1 then it 1. But if it has one 0 then out put is 0, regardelsess how many 1 it has for one day. 

[v-yuta-msft]

@Anonymous ,

---

So basically I want. Column A can either be 1 or 0 through a day. Which is colum B. 

So if cloumn C has 6 = 1 values and 0 = 1 on example 10 april = Will the out be 0. 

So if one values for a day is 1 then it 1. But if it has one 0 then out put is 0, regardelsess how many 1 it has for one day. 

---

Could show some sample data and give the expected result about your requirement?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.