Forum Discussion

AnthonyXelya's avatar
AnthonyXelya
Icon for Helper II rankHelper II
4 years ago

Join two tables with intersecting dates

Hello,   I have - a table with the absences of the agents of my enterprise : start and end dates, number of hours missed - a table with the contracts of the agents : start and end dates, number o...
dates
join
AnthonyXelya's avatar
AnthonyXelya
Icon for Helper II rankHelper II
4 years ago

Still nobody to help me? 😞

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    AnthonyXelya 

     

    Frankly, this might not be a easy thing for DAX. You may also consider using SQL script.

    • AnthonyXelya's avatar
      AnthonyXelya
      Icon for Helper II rankHelper II
      4 years ago

      How can I do that?