Hi Mynda, where is session 7.08 ? Yes from the dates after converting to List already, you mean create a custom column in table 2 to reference ...
thanks for your patience Mynda, not necessarily is exlude weekends, some how certain staff forgotten to input their temperature in the system, basi...
Hi Mynda, a brilliant way of using index with different order to create col 2 and col 3 However for 9/2/2020 should be 36.8 0 0 as the next ...
Hi Mynda, I am sorry if the sample data didn't reflect what I just explained, by the way will duplicating three sets slow down the query generation...
Hi Mynda, thanks for your reply Basically we wanted to track staff input their temperature measures into the applications, whether it is diligentl...
Hi Mynda Amazing, didn't know can split into row with conditions, there will be a lot of use case for me Thank you ! Jim Attached a...
Hi Eric, So you had done split to column in Power Query, you can change column in PQ to either Text or Number depending whether field require subs...
Hi Jane Joyce Not sure this is what you want Unpivot > Group by > aggregate so that you can find min of a list of dates (Col 1..... Col x)...
Apologise Sir, forgotton to insert the mock source to you, by the way, manage to develop the query and see whether you have more efficient way, or...
Hi Catalin Thank you it works perfectly if all days within a month can you enlighten me what if the days cross over to next month, what is t...
Hi Catalin Sorry my mistake Yes, for Staff A, only take into account 4/3/20 to 21/3/20 all the Zero, so the return should be 6 (there are 6 ...
wow Catalin, amazing, can explain the pattern in layman term, really want to learn from you