Dynamic Date Filter when there is a many-to-many relationship

[Anonymous]

Hi guys!

Help me out, please!

I have three tables: one calendar (dC) and the other two secondary (T1 and T2), but they contain the ID I need.

The two secondary tables are related in a very-to-many relationship (T1 <-->T2) and the calendar table is filtering the date of one of them (dC --> T1).

What happens is the following: when I'm going to create a table type look, I need the date filter (date range style) to show all the information regarding this range. I also need to put values ​​from T1 and also from T2 together. However, the T2 date does not match the AD range, thus generating all T2 date values ​​instead of the range.

I tried various types of DAX comparing the period contained in the table with the date filter, but without success.

can you help me?

OBS: what I need is a filter, in which when I put it inside the table type look, it can compare the T2 date with the AD range and if it's within that range, it will return 1, if it's outside the filtered date range , will return 0.

thanks guys!

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.