Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
66 | |
54 | |
47 | |
36 | |
34 |
User | Count |
---|---|
84 | |
70 | |
58 | |
45 | |
44 |