Forum Discussion

rdops's avatar
rdops
Helper III
6 years ago

Help comparing dates between tables

Hi there, I am hoping someone can help me with this. Have spent hours and hours looking through the solutions posted and cant figure out.   I have two different systems for people to enter timeshee...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Use CONCATENATEX(EXCEPT( <filtered dates from A>, <filtered dates from B>),[Date],",")

 

 

  • rdops's avatar
    rdops
    Helper III
    6 years ago

    Thanks Greg, I will try this one now to see if it works. Will report back (though not sure I understand how the filtered dates work but will give it a go). Thanks

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      rdops - If you have the names of the person in a visual then you could do something like:

       

      VAR __Name = MAX('Table'[Name])

      CONCATENATEX(

        EXCEPT(

          SELECTCOLUMNS(FILTER('Table1',[Name]=__Name),"Date",[Date]))

          SELECTCOLUMNS(FILTER('Table2',[Name]=__Name),"Date",[Date]))

        ),

        [Date],

        ","

      )

       

      So, basically, get me all the dates from table 1 and take away all of the dates from table 2 so now the ones left are the missing ones.

        

      • rdops's avatar
        rdops
        Helper III
        6 years ago

        Thanks Greg.

        I tried but couldnt make it work. I guess I am just to jr for the tool.

         

        Thanks anyway