Skip to main content

Power BI

Needs Votes

Analyse in Excel - Be Able to use Calculated Field

Vote (1) Share
Robin DELAGE's profile image

Robin DELAGE on 27 Jul 2020 15:09:29

In most of case when you wan't to make a substraction or a evolution pourcentage between to column it's quite difficult in a Power BI Report because you have to make a measure or a column, but it some time too difficul.

So one solution is to use Analyse in Excel that provide a lot more possibilité in term of Pivot Table.
But when you use a Power BI DataSet in Analyse in Excel you can't use the Excel fonctionality : Calculated Field
It would be great if we could use this.

Another related functionality that could be good is the possibilité to add a Calculated column in a specific Matrix in a Power BI Matrix (To have an evolution between two year for example, but without making a measure or column).

Thank you in advance.

(Sorry for my english, i'm French ;))