Skip to main content
Microsoft Idea

    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

    hvs 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

    Areef Ali 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

    Power BI User 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

    Power BI User 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

    Power BI User 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...