Correct date with Dax multiple records

Anonymous There is no calculations. The number is in the table above its the 4th column highlighted in yellow called # of Days. This number changes based on the Target Start and End Date the 6th and 7th column in the table. For Danielle Food 1st  Target Start Date is on the 6th row and Target Start Date is Nov 16, 2021 to Target End Date Mar 13, 2022 and is 3 which is what I want to return on a graph for 2022 from Jan 1, 2022 - Mar 13, 2022.

Then the 5th row the Target Start Date is Mar 14, 2022 to Target End Date Mar 15, 2022 and is 2.5 which is what I want to return on a graph for 2022 Mar 14, 2022 - Mar 15, 2022. Then on the 4th row is Target Start Date of Mar 16, 2022 and No Target End Date but this target is active per the Target Status (8th column) meaning on a graph of 2022 I want to use now its 3 so from Mar 16, 2022 to current date I want 3. 

I want if possible a formula that would be able to grab the correct # of Days (column 4) using the table based on the Target End Date (Column 6) and Target End Date (Column 7).