Forum Discussion

LoonaMoon's avatar
LoonaMoon
Frequent Visitor
2 years ago
Solved

Merge tables based on emails but compare dates first

Hi all. I need to merge two tables based on email, but first compare dates from both tables. Let me explain,   I have a table "Workplace SafetyTrainings" where we store dates and scores of each emp...
  • lbendlin's avatar
    2 years ago

    You shouldn't do that in Power Query.  Read about how to handle "Slowly Changing Dimensions"  (SCD) in DAX.