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
KeyurPatel14's avatar
KeyurPatel14
Responsive Resident
3 years ago

Hi PBI_Monkey ,

can you please use Power Query and Remove duplicates from the Date Column?
Try this and let me know if you have any queries.

  • PBI_Monkey's avatar
    PBI_Monkey
    Helper I
    3 years ago

    Thanks for the reply KeyurPatel14 

    Removing duplicates won't work as there is a code which is different on the row with the same date