Forum Discussion

goyasor's avatar
goyasor
Frequent Visitor
9 years ago
Solved

Join on Date Range

Hello everyone,   I've been struglling with the following issue for a few days and hope someone might be able to help.   I'm trying to merge 2 tables on date range without success.   The first ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    goyasor,

     

    Why do you need to do this is Power Query? We can get this result in DAX easily.

    Column = CALCULATE(COUNT(Table2[User]),FILTER(Table2,Table2[User]=Table1[User]&&Table2[Response_Date]>=Table1[Email_Date]&&Table2[Response_Date]<=Table1[Email_Date_7days]))

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

goyasor,

 

Why do you need to do this is Power Query? We can get this result in DAX easily.

Column = CALCULATE(COUNT(Table2[User]),FILTER(Table2,Table2[User]=Table1[User]&&Table2[Response_Date]>=Table1[Email_Date]&&Table2[Response_Date]<=Table1[Email_Date_7days]))

 

Regards,

Charlie Liao

goyasor's avatar
goyasor
Frequent Visitor
9 years ago

Thanks Charlie. That worked.