Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Checking values for each day measure

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. 

Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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.