Forum Discussion
Impactful Individualdate table is not filtering sales
Hi
Your Order Date contains time as well. To have DimDate filter Fact table, both columns would need to be only Date. But this cannot be done by only changing the Order Date column’s format in the data view or model view, as the underlying values still include the time portion. Since i'm not able to transform your Data in Power query, i created one date column from Order Date. and rebuild the relationship.
Date =DATEVALUE(Sales_Orders[OrderDate])
Super UserHi
Your Order Date contains time as well. To have DimDate filter Fact table, both columns would need to be only Date. But this cannot be done by only changing the Order Date column’s format in the data view or model view, as the underlying values still include the time portion. Since i'm not able to transform your Data in Power query, i created one date column from Order Date. and rebuild the relationship.