Last answered:

03 Nov 2021

Posted on:

02 Nov 2021

0

Resolved: Conditional columns in PowerBI vs Excel

Hi
assuming we are importing the data from Excel, what would be the advantage to have the conditional columns made in PowerBI vs in Excel ?

thank you

3 answers ( 1 marked as helpful)
Instructor
Posted on:

02 Nov 2021

0

Power BI is your data viz tool. It is powerful enough to do everything Excel does and more. If you create the custom column in Excel you will have to maintain it inside Excel and then refresh inside Power BI. If you do the transformations inside Power BI everything will be in one place.

Posted on:

03 Nov 2021

0

thank you for your answer.
I'm worried about memory consumption. following the training I feel it looks like adding calculated col is not a wise option.
with this regard, would it be better to do the columns calculation in excel rather Power BI ?

thank you

Instructor
Posted on:

03 Nov 2021

0

it all depends on the use case, in what context are you looking for adding a calculated column? In general more columns mean more memory, so measures should be used instead of calculated columns, but if you need a calculated column for a key or to make a date or to build a text column that is the only way

Submit an answer