Forum Discussion
add custom column to table
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.
Community ChampionAnonymous
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
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.
- az38
Anonymous
sorry, it was my bad, of course.
for you task you can use table Visual, not matrix
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.