Forum Discussion

Sandeep13's avatar
Sandeep13
Helper III
3 years ago
Solved

Add same column rows with same column next row

Hi All I have one column called ColumnA andI want some like below in Total column in powerbi. Note: I dont have any other column in data model. ColumnA Total 0.15%   0.14% 0.29% 0.1...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Sandeep13 ,
    It is working for me. Please see below screenshot :

    Try to adding the Index column in Power Query editor using this

    Please sort your table before adding the Index column.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Sandeep13 ,
You need to create an Index column in your table first and then add a calculated column with following DAX formula:

Total (column) =
var previndex = CALCULATE(MAX(Sheet1[S.no]) - 1)
var prevvalue = CALCULATE (SUM (Sheet1[ColumnA]),FILTER (Sheet1,Sheet1[S.no] = EARLIER (Sheet1[S.no]) - 1))

Return IF(previndex > 0, CALCULATE(SUM(Sheet1[ColumnA]) + prevvalue), BLANK())

Format the above column as percentage.

 

This will give you the desired result(below screenshot):

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!