Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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.
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.
Hi,
In the Query Editor, just change the data type of that column to Date.
Thanks Ashish for the response. But will It be an Issue if I dont convert to date datatype?
I do not hink so but please try.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |