Forum

Calculated Columns ...
 
Notifications
Clear all

Calculated Columns - Power Query vs PowerBI

3 Posts
2 Users
0 Reactions
107 Views
(@blankab)
Posts: 63
Estimable Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
(@blankab)
Posts: 63
Estimable Member
Topic starter
 

Thank you so much, Mynda!

Blanka

 
Posted : 29/04/2019 11:02 pm
Share: