Forum Discussion
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...
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.
Hey Thank You its working in my dummy data but when i am implementing in my actual data its give me wrong output.
I have 1M Plus data
Total (column) =
var previndex = CALCULATE(MAX(Master[Num_Rnk]) - 1)
var prevvalue = CALCULATE (SUM (Master[Manual_Group_Volume]),FILTER (Master,Master[Num_Rnk]= EARLIER (Master[Num_Rnk]) - 1))
Return
IF(previndex > 0, CALCULATE(SUM(Master[Manual_Group_Volume]) + prevvalue), BLANK())
Can you share a sample of your data with me? You can modify your data if needed and just share a file with 100 rows or so.