Forum Discussion

nmasimore's avatar
nmasimore
Helper I
4 years ago
Solved

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 w...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

nmasimore , I agree with Syk . If you can create it in Power Query (or even better at the data warehouse) then do so. I find that DAX is handy for creating calculated columns that require referencing multiple tables, but that shouldn't be a common requirement.