Issues with One to Many relationship and Duplicates from a specific column

[10168]

Please bear with me as I'm extemely new to PowerBI modeling and wiritng DAX

I have created a one to many relationship between these two tables below (One of them is Date table and other one has all kinds of dates related to scheudling). The relationship is between taskFinishDate(Many) and Cal Date(Unique). FiscalYear is a column in CalDate and whenever I bring in this column into the Visual it starts creating duplicates. I'm trying to avoid this. Can someone shed somelight on why is this happening. Please! 

Also I'm trying to write some DAX based on a different column in TaskActivity_fact and it didn't seem to return what I am expecting 

Planned to Date =

CALCULATE(COUNT('taskactivity_fact'[task_baselinefinishdate]), FILTER('DimDate_BWL','DimDate_BWL'[FiscalYear] = 2024 && 'DimDate_BWL'[FMCategory] IN {"PREVIOUS PERIOD","PREVIOUS"}))

I'm expecting that DAX is going to filter as I have a relationship that exists

Please help and also let me know if I can provide anything more to be specific. thank you again!!

[Ashish_Mathur]

Hi,

While in the first image both date columns are right aligned (which provied that the date types of those columns is Date) bu in the second image, i see that the finish date is left aligned (thereby proving that the Date type is text).  In the Query Editor, please ensure that the Date type of the Finish date column is Date.

[10168]

Thank you Ashish, I made sure that both the columns are the same data type - Date, however I'm still having the same problem, the FiscalYear column is a whole number. Any thoughts please? thank you

[Ashish_Mathur]

Cannot help without seeing the file.