Skip to main content

    Power BI

    Needs Votes

    Inserting calculated row fields or rows to Power BI table or matrix.

    Vote (63) Share
    's profile image

    on 10 Nov 2017 03:04:26

    Hello Everyone. I don´t see the ability to insert calculated rows and rows to Power BI tables or matrixs. In finance community this is basic. Are you planning to develop this? If you already do so, big favor, can you please send me a link?
    Thank you,

    Comments (12)
    's profile image Profile Picture

    JackT on 05 Jul 2020 23:34:54

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    There are a LOT of things missing in PBI, but I'm afraid but the lack of something as basic as the ability to add a calculated row is simply astounding.

    And the Rube Goldberg-style workarounds that are offered for these missing features just amplifies how ridiculous the situation is.

    's profile image Profile Picture

    IH on 05 Jul 2020 23:26:57

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    The lack of calculated rows is probably the biggest hurdle in migrating from excel to powerbi for reporting.

    's profile image Profile Picture

    yashGo on 05 Jul 2020 23:12:18

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    '@martin Kratky, your link is not available

    's profile image Profile Picture

    Martin Kratky on 05 Jul 2020 23:08:25

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    This is an important feature but there are workarounds: you can use a DAX measure that adds calculation logic.
    We have an example here: http://managility.com.au/2017/12/18/agility-planning-matrix-light-visual/ (AP Matrix visual as in the sample is not required this also works with the normal matrix)

    's profile image Profile Picture

    Ernesto Núñez on 05 Jul 2020 23:04:26

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    I hope that this feature is release soon because as a finacial anaylst would be very useful.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:04:21

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    Hi as HPI financial analyst it would be very useful to have these feature to be able to insert calculated rows

    's profile image Profile Picture

    Victor on 05 Jul 2020 23:04:21

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    HPI Finance Mexico

    's profile image Profile Picture

    Gaby Celaya on 05 Jul 2020 23:04:21

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    HPI Finance Mexico

    's profile image Profile Picture

    Ana on 05 Jul 2020 23:04:21

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    calculated fields for rows are as important as calculated fields as columns, please provide a solution!

    's profile image Profile Picture

    Miguel on 05 Jul 2020 23:04:20

    RE: Inserting calculated row fields or rows to Power BI table or matrix.

    Hi, I am also a member of Hewlett Packard Ink and business partner of Santiago Casillas...we really need this capability within Power Bi. Hope you can support

    Miguel