Forum Discussion
ffilter two tables
Hello, I would like to filter two tables in the report, the tables have no relationship. In both tables there is a "date" field and I would like to put a filter on that it also affects the other tabl...
wiktor_nus , My advice would be to create a date table join with those two and use that as slicer
Or have measures like
calculate(Sum(Table1[Value]), filter(Table1, Table1[Date] in values(Table2[Date]) ) )
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
unfortunately they are connected by a different relation which does not allow for a connection after the date field.
unfortunately this measure does not work:
calculate(Sum(Table1[Value]), filter(Table1, Table1[Date] in values(Table2[Date]) ) )