Creating Logic to find whether columns in one table matches other columns in other table
Hi Team, I have 2 tables: Door table as below: Store Status table as below: They are modelled as below (let me know if we can better model it-suggestions are welcomed): Now, I need to create a logic(Breach) to find when Door Table - Status column being Open when Store Status table - Status column being Closed (indicated by - 'C'). During this logic, we have to make sure it satisfies below conditions: DateTime column of Store Status table should match the createdon column of Door table Store id column of Store Status table should match the siteid of Door table Output should return 1 if the conditions meets else 0. Could you please help me create a logic for this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan
The Formatting got wrong!!!!!
Hey! Someeone please help me with this... I have few data sets with me and both of them have dates coloumn in it. So I wanted to syncronize the dates from one sheet to another so I copied both in one sheet. Since is a daily data of 3 years its difficult tally them as the formatting of one sheet was different. So I want to change the formatting same as sheet 1 but the formatting fuction changes only selective cells which does not make any sense. Follow the image below....if the value in one list exists in another array.
Hello, How can it be made to change all the data at once without breaking the formula? Excel file is attached. İF(A8:A109 (bir değer) = Girişler!Y2:Y26 (if on this list); (does not take any action. Therefore, all multipliers become 1.) ; İNDİS(OQ4:PB4;SIRALI(1;9;1) ) (If it's not in the list, you run this formula.) ) =EĞER($A8:$A109="";"";LET( itemCode;PTC!A7:A109; start;KAÇINCI(Mix!$D$1;PTC!$C$7:$K$7;0); BlockStart; KAÇINCI(OQ5;PTC!5:5;0)+start-1; dataPlus;FİLTRE(PTC!7:109;((SÜTUN(PTC!5:5)>=blockStart)*(SÜTUN(PTC!5:5)<=blockStart+8)) range;BIRAK(dataPlus;1) ) / İNDİS(OQ4:PB4;SIRALI(1;9;1)) ; veri;BIRAK(aralık;;-1); dataSonraki;BIRAK(aralık;;1); çeyrekler;BIRAK(AL(dataPlus;1);;-1); sonuç;(data-dataNext*(SAĞDAN(çeyrek)<>"3")); sonuç/$A$2 )) I want results like yellow products where I want them.
