Forum Discussion

JL475's avatar
JL475
New Member
4 years ago
Solved

Filtering a table with data from another table

Hello, I'm relative new on Power Bi. I've been looking for a way to filter a table with data from another table. Example:  Table A Bank Account Date A 1 01/01/22 B 2 01/02/22 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi JL475 ,

     

    Please check the formulas:

    Table = 
var tableb = ALLEXCEPT('Table B','Table B'[Finish Date])
return
EXCEPT('Table A',tableb)

    Or

    Table = 
var tableb = ALLEXCEPT('Table B','Table B'[Finish Date])
return
EXCEPT('Table A',EXCEPT('Table A',tableb))

     

    Best Regards,

    Jay