Notifications
Clear all
Power BI
3
Posts
2
Users
0
Reactions
67
Views
Topic starter
Where is it better to create calculated columns? In the Power Query while getting the data to PowerBI, or in PowerBI itself?
Is there a difference at all?
Thank you,
Blanka
Posted : 29/04/2019 11:01 am
Hi Blanka,
It is more efficient for Excel if you add your calculated columns in Power Query as that avoids having a load of DAX formulas in your Power Pivot model in Power BI.
Mynda
Posted : 29/04/2019 5:50 pm
Topic starter
Thank you so much, Mynda!
Blanka
Posted : 29/04/2019 11:02 pm