Forum Discussion
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 ...
Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26Rhnn0tywq_Ay2nvOE?e=9zQPiw
If I understand you correctly, then you first need to do
1) Right Anti Join (table1,table2)
2) combine what you got with 1 table
---------
I can't do this without a real example.
read this:
https://gorilla.bi/power-query/join-types/
Hi Ahmedx ,
I tried the anti join and then appended the result with Table 1.
I get strange results:
I've attached the .PBIX
https://www.dropbox.com/s/pvqgf5jn616249i/WR.pbix?dl=0
Thanks
Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26Rhnn0tywq_Ay2nvOE?e=9zQPiwThank you Ahmedx. Seems I have to include 3 fields to join in the right-anti join.
Thanks, your solution worked.