Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Solved! Go to Solution.
Couple possibilities. One, check your filter direction on your relationship to make sure it is the right direction. Second possibility is that one of your dates contains time stamps that are other than midnight. True date only columns have a time component that is 0, which is midnight but if your dates in your fact table have a real time component other than midnight, they won't match up.
Hi vannikannan ,
After you change Date/Time to Date type, can you build relationship between the two tables? If still can't, you may create a calculate column use
Result = Format(Table[Column],"MMYY")
Or
Result = Date(Table[Column])
Regards,
Jimmy Tao
Hi vannikannan,
As mentioned above, this may caused by something wrong with your table relationship. Could you share some screenshots of your table structure and relationship?
Regards,
Jimmy Tao
Proud to be a PBI Community Champion
Couple possibilities. One, check your filter direction on your relationship to make sure it is the right direction. Second possibility is that one of your dates contains time stamps that are other than midnight. True date only columns have a time component that is 0, which is midnight but if your dates in your fact table have a real time component other than midnight, they won't match up.
I would never have guessed that date table will not match with Date/Time column in Fact table if time is other then midnight. I was banging my head against the wall for some time trying to figure out what the hell is wrong.
Thank You!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |