Will filtering be an issue in the following scenario?

[imagautham]

I have two tables. Calendar is a dimension table whose granularity is one day per row. Calendar table is filtering the sales which is my fact table. The common column connecting the two columns is the date column.

The date column in my calendar is of the format MM/DD/YYYY (Example:12/25/2019)

The date column in my sales table is of the format MM/DD/YYYY HH:MM:SS (Example: 12/25/2019 12:00:00 AM)

I know that we can convert the date column in sales table to match the date column in calendar table.

But I'm curious to know if I don't convert and leave the column as it is, Will Power BI able to handle this or will there an issue in this case?

[v-henryk-mstf · Accepted solution]

Hi @imagautham ,

Yes. The date field and the date/time field are two different data types. You need to keep their types the same by means of conversion, otherwise it will cause filtering errors.

Reference to the following similar solution is also caused by this type of problem.

details

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the Query Editor, just change the data type of that column to Date.

[imagautham]

@Ashish_Mathur 

Thanks Ashish for the response. But will It be an Issue if I dont convert to date datatype?

[Ashish_Mathur]

I do not hink so but please try.