Date Table Relationships Not working

[Flawn]

Hello All,

I have a really peculiar issue with my data table that I need help solving:



The first set of date info is from the find table's internal dates (which the date table is related to that table by) the second set of dates - which are (mostly) blank, are from the date table itself. After some looking around it appears that when I try to use filters via the date table, the overwhelming majority - but not all-  of find table's dates read as 'blank', second image should help clarify:

I have no idea what the heck is going on here - I appreciate any help that people can provide.

Warm Regards,
Flawn

 

[Ritaf1983]

Hן @Flawn 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[Flawn]

Not a problem, PBIX here:https://drive.google.com/file/d/1GxtoCfmo90ZfkphF5mWzG8wN3UCHN6UJ/view?usp=sharing 

I really had to carve massive chunks off of the data to conform to our privacy policies so pardon the mess. The issue-relevent date data and relationships have been preserved so it should be fine.