add custom column to table

[Anonymous]

Hi all,

I have a very easy quesion.

Is it possible to add a new column which calculated with other 2 column ?

My table like as below.

I want to change it like that.

Finally i'm using Direct Query method, not import data. 😞 BTW if it is possible on import data let me know.

Any idea ? 

[az38]

Hi @Anonymous 

try to create a measure 

Measure = SUMX('Table';[KPI2]-[KPI1])

for import mode it's enough to create a column

Column = [KPI2]-[KPI1]

[Anonymous]

Hi @az38 

Actually that's not what i want.

I don't want to add it like measure. If i create it like measure it going to show on row, i need to show it on columns.

Does it make sense to you ?

[az38]

@Anonymous 

You should be able to use Measure as a column for matrix visual

Anyway, if you use directquery you also can create a column with some limitations

Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

[Anonymous]

@az38 i'm unable to use it.

Actually maybe i don't need to create new measure.
Some BI Tools makes it possible to create calculation on table. without creating new object on model.
For Ex:

I just want to be sure if it is possible on PBI to do something like that. I want to add variance of some KPI on table. 
I created a measure like you but it isn't working. Here is my pbix.

[Anonymous · Accepted solution]

@Anonymous 

With Power Bi, you will need at least create a column or a measure for the variance to displayed it on the report.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

@Anonymous 

sorry, it was my bad, of course.

for you task you can use table Visual, not matrix