Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
10168
Helper I
Helper I

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

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! 

 

10168_0-1699652878700.png

 

10168_1-1699652910502.png10168_2-1699652960698.png

 

 

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!!
3 REPLIES 3
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Cannot help without seeing the file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.