Forum Discussion

sapirmarko's avatar
sapirmarko
Icon for Helper I rankHelper I
3 years ago

filter the report by another table

Hi evryone I have scheme with this relatinship:   I want to filter all the report (filter all pages) that will show the record that  Start date( Order_creaor_table) >= Sales_table(date) th...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could create a new column in the Sales table like

Is After Start Date = 'Sales'[Date] < RELATED( 'Order creator'[Start date])

And then use this column as a report level filter.