Forum Discussion
Creating a Column - Model Efficiency/Storage/Best Practice - DAX vs. PowerQuery?
Hello
I have a transaction table and a calendar table. The transaction table has a Datetime column, not a date column.... so I am creating a column in the transaction table called "Date" and it will contain strictly the date (no time).
In terms of model efficiency/data storage/best practice, should I create this column using PowerQuery or DAX?
Open-ended question: When is it better to create columns using Power Query? When is it better to create columns using DAX?
It's almost always better to create it in Power Query. You can read more about it here: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
4 Replies
It's almost always better to create it in Power Query. You can read more about it here: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
Thank you AllisonKennedy !
