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

Thank you Ahmedx. Seems I have to include 3 fields to join in the right-anti join.

Thanks, your solution worked.