Skip to main content

    Power BI

    New

    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

    2b56654b 5f86-4fde-a0c8-a80cf9635548 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

    410d9387 ebbf-49c1-b69a-e420ea53fea0 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

    558986cb d1d8-40bb-808a-ffd978b83f6e 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

    c1d64842 f210-4e95-80ef-8e133c5488b3 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

    9c504db3 2998-4c6c-b41d-8006120ec611 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

    65e9a60a d448-4438-b726-eaf389448bcb 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

    fbb845f5 24fc-4c66-9be7-c92e0a84dbde 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

    8879cf07 1215-49ec-93d2-23cec2bc557e 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

    e15aba2e e52d-4118-9899-6fbbdb8615f7 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

    67e2ab1c 08da-4b50-939a-b67860b879e8 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