Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!