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.

Sandeep13's avatar
Sandeep13
Helper III
3 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • Sandeep13's avatar
      Sandeep13
      Helper III
      3 years ago

      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%

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.