Forum Discussion
Solved
How to avoid having date and date/time column (Incremental Refresh and Calendar Table)
Hello, I am currently building a data model, where I have various date/time columns. In this regard I found that according to best practices I should have a calendar table. Since I don't need th...
Hi IvanKostov ,
If you need a date column (calendar relationship) and you need a datetime column (incremental refresh) then you need a date column and a datetime column, no way around that I'm afraid.
In Power Query, keep your datetime column as-is, then create a new custom column using the following:
Date.From([datetimeColumn])Using Date.From will prevent query folding from breaking if your source is foldable.
Pete
Thanks Pete!