Forum Discussion

maulikparmar1's avatar
maulikparmar1
New Member
3 years ago

power bi

HELLO 

I AM USEING POWER BI CREATE FOR DYNEMIC DASHBOARD 

BUT I HAVE SOME QUASTIONS TO POWER QUERY 

HOW TO ADD ROW GRAND TOTAL THEY USE I CROSS EXCAMIN TO MY ALL CHART SO HOW CAN I ADD GRAND TOTAL IN  

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    3 years ago

    Hello maulikparmar1,

     

    With the "Add Column" function, you may add row grand totals to a table in Power Query by creating a formula that adds the values in each row.

     

    = Table.AddColumn(#"PreviousStep", "Total", each [Column1] + [Column2] + [Column3])
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    3 years ago

    Replace "PreviousStep" in this formula with the name of the query's previous step, and "Column1," "Column2," and "Column3" with the names of the columns you want to sum. If necessary, you can add extra columns or change the formula.

     

    By dragging the total column onto your visual or table after it has been inserted, you can use it in your Power BI report. You can easily remove the step from your query and then refresh your report if you decide to later remove the total column.

     

    It should be noted that this method functions for tables in Power Query, the data preparation and transformation tool in Power BI.