Skip to main content

    Power BI

    Under Review

    how about some power query functions: running total function, offset function, geometric mean

    Vote (53) Share
    rashid's profile image

    rashid on 13 May 2015 06:30:20

    i

    Administrator on 05 Jun 2015 23:41:13

    We'll consider this as improvements to Power Query / Power BI Designer. Thanks for your feedback!

    Comments (5)
    rashid's profile image Profile Picture

    d9838a37 6138-4f24-9cf3-e2e59b236fa7 on 05 Jul 2020 22:59:21

    RE: how about some power query functions: running total function, offset function, geometric mean

    URGENT

    Miguel: please have the function of Running totals created soon in the Dashboard, it is a presentation function, not data nor Dax.

    Not having a running total in the Dashboard is a Nock Out critieria in the selection of BI tools.

    rashid's profile image Profile Picture

    6f2f2635 6e44-4885-bef9-86885f69e399 on 05 Jul 2020 22:33:22

    RE: how about some power query functions: running total function, offset function, geometric mean

    You guys have been doing great work. Just to support Power Query - a running total function is critical - can you give an update on this

    rashid's profile image Profile Picture

    28848a1b b0cc-4153-9fa8-c2bb218f889d on 05 Jul 2020 22:26:48

    RE: how about some power query functions: running total function, offset function, geometric mean

    Please add Running Total function (right click to select). This is more helpful than building DAX in table data. Thanks for your post Rashid.

    rashid's profile image Profile Picture

    b1b0d393 2f31-4da7-9f2c-cb688e87fc0a on 05 Jul 2020 22:25:18

    RE: how about some power query functions: running total function, offset function, geometric mean

    This is for Miguel! Please make running totals/cumulated totals a standard functionality in Power BI like it is in PowerPivot (right click - display result as running total in...). It is not user friendly with DAX formulas. If you search for "cumulative totals" and "running totals" in the improvement ideas you will see that it appears several times under different headings. So the votes should be cumulated and thus get higher priority.

    rashid's profile image Profile Picture

    b1b0d393 2f31-4da7-9f2c-cb688e87fc0a on 05 Jul 2020 22:21:17

    RE: how about some power query functions: running total function, offset function, geometric mean

    PLease make this functionality standard - especially the running totals function. In standard "PowerPivot" I have the option to right click in the pivot table and choose "Display result as - running total in - e.g. calendar weeks". It should be possible in PowerBi as well - without having to create DAX measures and other wizard stuff...