Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Sandeep13
Helper I
Helper I

Add same column rows with same column next row

‎06-22-2023 12:45 AM

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.

ColumnATotal
0.15% 
0.14%0.29%
0.10%0.24%
0.09%0.19%
0.09%0.18%
0.09%0.17%
0.08%0.17%

@Chnaexpt 

@power 

@comms @alexp  @ALLQ 

 

 

Labels:
Message 1 of 9
546 Views
0
1 ACCEPTED SOLUTION
Ankita21
Frequent Visitor
In response to Sandeep13

‎06-22-2023 07:40 AM

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

aabadalwar_0-1687444476822.png

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

aabadalwar_1-1687444652301.png

Please sort your table before adding the Index column.

View solution in original post

Message 8 of 9
467 Views
8 REPLIES 8
Sandeep13
Helper I
Helper I

‎06-22-2023 06:23 AM

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 

 

Sandeep13_0-1687440135754.png

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())

 

Message 5 of 9
480 Views
0
Ankita21
Frequent Visitor
In response to Sandeep13

‎06-22-2023 06:43 AM

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.

Message 6 of 9
474 Views
0
Sandeep13
Helper I
Helper I
In response to Ankita21

‎06-22-2023 07:06 AM

I am sharing  few records for your reference. I am not adding index_coloum 

Manual_Group_Volume is % of Total_Count  (sum(Total_Count)/Total_Count) just for your referenece.

CLIENT_SUPPLIERCHANNELINSERT_DTHIT_INDTOTAL_COUNTPROD_TYPESector.CategoryProduct.BureauYearManual_Group_Volume
PC Financial Services Pvt. Ltd.CPU_2Thursday, September 30, 2021MATCH448270CIRNBFCConsumer20210.15%
PC Financial Services Pvt. Ltd.CPU_2Friday, October 29, 2021MATCH416276CIRNBFCConsumer20210.14%
PC Financial Services Pvt. Ltd.CPU_2Thursday, July 29, 2021MATCH299861CIRNBFCConsumer20210.10%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, May 9, 2023MATCH279887ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.09%
CapFloat Financial Services Pvt LtdCPU_2Sunday, August 14, 2022MATCH263166ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.09%
CapFloat Financial Services Pvt LtdCPU_2Saturday, August 6, 2022MATCH262598ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.09%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, July 6, 2022MATCH248081ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.08%
PC Financial Services Pvt. Ltd.CPU_2Friday, July 30, 2021MATCH240220CIRNBFCConsumer20210.08%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, April 26, 2023MATCH232250ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.08%
CapFloat Financial Services Pvt LtdCPU_2Saturday, January 8, 2022MATCH225790ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.08%
PC Financial Services Pvt. Ltd.CPU_2Tuesday, June 29, 2021MATCH217030CIRNBFCConsumer20210.07%
PC Financial Services Pvt. Ltd.CPU_2Monday, August 30, 2021MATCH215231CIRNBFCConsumer20210.07%
CapFloat Financial Services Pvt LtdCPU_2Saturday, January 28, 2023MATCH210542ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.07%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, November 29, 2022MATCH202276ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.07%
CapFloat Financial Services Pvt LtdCPU_2Saturday, October 22, 2022MATCH178189ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.06%
CapFloat Financial Services Pvt LtdCPU_2Thursday, April 21, 2022MATCH176502ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.06%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, May 31, 2023MATCH171882ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.06%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, May 10, 2023MATCH168478ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.06%
CapFloat Financial Services Pvt LtdCPU_2Saturday, February 18, 2023MATCH161517ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.05%
CapFloat Financial Services Pvt LtdCPU_2Thursday, December 22, 2022MATCH161247ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.05%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, March 28, 2023MATCH159866ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.05%
CapFloat Financial Services Pvt LtdCPU_2Sunday, January 29, 2023MATCH153123ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.05%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, March 2, 2022MATCH151364ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.05%
CapFloat Financial Services Pvt LtdCPU_2Friday, October 21, 2022MATCH149444ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.05%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, December 28, 2021MATCH137470ONLINE ACCOUNT REVIEWFintech NBFCConsumer20210.05%
CapFloat Financial Services Pvt LtdCPU_2Monday, November 28, 2022MATCH136228ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.05%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, March 7, 2023MATCH134849ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.04%
CapFloat Financial Services Pvt LtdCPU_2Tuesday, February 1, 2022MATCH134193ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.04%
Acko General InsuranceCPU_2Thursday, July 1, 2021MATCH132235CCM_SMARTMATCH_ACKOInsuranceConsumer20210.04%
PC Financial Services Pvt. Ltd.CPU_2Tuesday, August 31, 2021MATCH128269CIRNBFCConsumer20210.04%
CapFloat Financial Services Pvt LtdCPU_2Wednesday, April 20, 2022MATCH128226ONLINE ACCOUNT REVIEWFintech NBFCConsumer20220.04%
CapFloat Financial Services Pvt LtdCPU_2Friday, May 26, 2023MATCH127819ONLINE ACCOUNT REVIEWFintech NBFCConsumer20230.04%

 

 

Message 7 of 9
470 Views
0
Ankita21
Frequent Visitor
In response to Sandeep13

‎06-22-2023 07:40 AM

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

aabadalwar_0-1687444476822.png

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

aabadalwar_1-1687444652301.png

Please sort your table before adding the Index column.

Message 8 of 9
468 Views
Sandeep13
Helper I
Helper I
In response to Ankita21

‎06-22-2023 11:41 PM

Hi @aabdalwar,

 

Thank You its worked😊 

Message 9 of 9
449 Views
0
Sandeep13
Helper I
Helper I

‎06-22-2023 05:54 AM

Hey 

Thank you for your response. But I am getting data like this when i  apply your logic in my data.

Total (column) =
var previndex = CALCULATE(MAX(Sheet1[Index]) - 1)
var prevvalue = CALCULATE (SUM (Sheet1[Sales_Percentage]),FILTER (Sheet1,Sheet1[Sales_Percentage] = EARLIER (Sheet1[Index]) - 1))
Return
IF(previndex > 0, CALCULATE(SUM(Sheet1[Sales_Percentage]) + prevvalue), BLANK())
 
Note: I created index column 
 

Sandeep13_1-1687438441285.png

 

kIndly check

Message 3 of 9
488 Views
0
Ankita21
Frequent Visitor
In response to Sandeep13

‎06-22-2023 06:07 AM

Hey @Sandeep13 
Can you please try to change the column name from "Index" to something else? 
Since it is a Power BI keyword it might affect the calculation. I faced this same issue in the begining when i was solving your problem statement.

Message 4 of 9
486 Views
0
Ankita21
Frequent Visitor

‎06-22-2023 02:54 AM

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):
image.PNG

 

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

Message 2 of 9
500 Views

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All