Forum Discussion

PBI_Monkey's avatar
PBI_Monkey
Helper I
3 years ago
Solved

Get 1 Date per code in table

Hi all,   I have a table with the following columns: Code Date        Time         code isdefault A 28/03/2023 0700-2100 N FALSE A 28/03/2023 0700-2100 T TRUE A 29/03/2023 0700-2100 N FALSE A ...
Need Help
PBI_Monkey's avatar
PBI_Monkey
Helper I
3 years ago

Hi Ahmedx ,

 

Thanks for the cool reply.

I tried your solution but it doesn't work. Seems to be excluding alot of data.

I basically have 2 subsets of data (2 queries which I append into 1) - See screenshot

The resulting table must have all data from Table 1 and not matching rows from the 2nd Table.

So from table 2 in this example, I want to show the rows from 1st April to 5th April.

Business   Date               Time           Code     isdefault
A                28/03/2023 0700-2100  N          FALSE
A                29/03/2023 0700-2100  N          FALSE
A                30/03/2023 0700-2100  N          FALSE
A                31/03/2023 0700-2100  N          FALSE
A                1/04/2023 0700-2100     T          TRUE
A                2/04/2023 0700-2100     T          TRUE
A                3/04/2023 0700-2100     T          TRUE
A                4/04/2023 0700-2100     T          TRUE
A                5/04/2023 0700-2100     T          TRUE

 

Thanks