% Running Total in Power BI

srehman

Board Regular
Joined
Jan 4, 2020
Messages
175
Office Version
  1. 2016
Platform
  1. Windows
Hi Team,
As i am new in Power Bi need some help i have achieved my results by Pivot table.
I need to get same results in Power BI ,
From my data i have a column of Order ID : "221123814" thousands of different order IDs.

1.I have calculated "count" of order IDs . By clicking right click on value
2. I have calculated "% from grand total" count of order IDs. By clicking right click on value


3 . Now i have to calculate % of running total in Power Bi
is there any easy process P Bi like in pivot table as mentioned in snapshot.
 

Attachments

  • Percenatge running total in Power BI.PNG
    Percenatge running total in Power BI.PNG
    89.6 KB · Views: 6
  • Running total like in Pivot Table.PNG
    Running total like in Pivot Table.PNG
    59.5 KB · Views: 7

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,113,745
Messages
5,543,960
Members
410,586
Latest member
acadavid86
Top