Forum Discussion

PowerMyBI's avatar
PowerMyBI
Helper I
5 years ago
Solved

Filter between tables

Hi Power BI Community,   I am trying to sum and filter results between two tables. The result we are hoping to achieve is to sum the available hours in Table1 based on if the staff member is employ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    PowerMyBI , Create a new column in table 2

     

    sumx(filter(Table1, Table1[start date] <= Table2[Month] && (isblank(Table1[EndDate]) || Table1[EndDate] >=Table2[Month])),[HoursAvailable])

amitchandak's avatar
amitchandak
Super User
5 years ago

PowerMyBI , Create a new column in table 2

 

sumx(filter(Table1, Table1[start date] <= Table2[Month] && (isblank(Table1[EndDate]) || Table1[EndDate] >=Table2[Month])),[HoursAvailable])

PowerMyBI's avatar
PowerMyBI
Helper I
5 years ago

Yes this worked perfectly thank you amitchandak ! I see what I was doing wrong in my first attempts now.