Forum Discussion

PowerMyBI's avatar
PowerMyBI
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    5 years ago

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