Filters in related tables

[Syndicate_Admin]

Hello.

I have a report that I fit by a date field in the Value_entry table, which is related to the Budget tables-... and Sales_line.

The filter is done at the month level *, the current one, so in the table where the field that is taken to filter (Value_entry) are not every day of the month, but in the other two tables there is data for all the days of the month, and only those that are in the first one appear. How could I fix it by making me leave the whole month?

Thanks a lot!

*

[amitchandak]

@Syndicate_Admin , You should think about common/bridge tables

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

https://www.seerinteractive.com/blog/join-many-many-power-bi/

if need create date from month and join it with date table