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.
Hi people,
So I have this situation. I created a calendar table and the "Date" in date/time format is not able to filter in slicers the dates from a fact table. The dates in fact table are also in date/time format and come from a SQL database.
Then I went to power query, and changed the date format from the fact table, from date/time to date and it started working.
Why is this, and do I need to duplicate columns in the fact table with a date format? Because I also need the hours..
Solved! Go to Solution.
@campelliann , It always good to have a date without a timestamp. This can make sure you have a join with other dates easily.
Changing format in DAX, do not ensure that DateTime is the only date. It still remains date with time
In power query you can get date like
DateTime.Date([Datetime column])
@campelliann , It always good to have a date without a timestamp. This can make sure you have a join with other dates easily.
Changing format in DAX, do not ensure that DateTime is the only date. It still remains date with time
In power query you can get date like
DateTime.Date([Datetime column])
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 |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |