Forum Discussion

KuntalSingh's avatar
KuntalSingh
Helper V
2 years ago
Solved

Need help on filtering value

I have a value in sheet Calculation I need to filter the data based on that value into second sheet Main and based on filtered value copy all the rows from sheet Main and paste them into sheet Calcul...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Can you please add a column delimiter?

  • KuntalSingh's avatar
    KuntalSingh
    2 years ago

    Thanks Ibendlin

    I got the solution

lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

KuntalSingh's avatar
KuntalSingh
Helper V
2 years ago

Have a value that user input on Sheet 1 in column A  need that value to be filtered  on sheet 2 in coloumn A. Colounm A have merged data based on filtered rows in sheet 2 copy that rows to sheet 1. Below is the sample data of sheet 2 of column A.

 

Sheet 1 Coulumn A user inout value is 0013266161

Sheet 2 Column data

Merged
0015None4300013567NoneEMD converted into SD_Balance refundedNone0015None
0033None4300017001None*HDFC0000001*N036211396371298* WO 26806735 SDNoneWO 26806735 SDNoneBagging machine repair 33
0028374836/00000None8350025544None2% SD AGAINST RUNNING BILLNone0033NoneInternet Pmnt-0010104185
00030548None1000248None5826  -  CONTRACT CELLNone0010037452/PEBGNone04031IG220000066
00030548None1000249None5827  -  C0NTRACT CELLNone0010038140/PEBGNone04031IG220000067
00030548None1000431None5529  -  CONTRACT CELLNone0010035829/PEBGNone6278NDDG00006322
00010710None1000432None5530  -  CONTRACT CELLNone0010035830/PEBGNone6278NDDG00006622
00030548None1000538None5587  -  CONTRACT CELLNone0010034257/PEBGNone04031IG210000063
00030548None1000539None5588  -  CONTRACT CELLNone0010034443/PEBGNone04031IG210000062
00044428None1000278None5853  -  ENGGNone/SEDENoneCINGGU2200848
00082907None1000376None6460  -  H,  S  &  ENone0010043470/SEDENone852020208463
0028878382/00000None8350006041NonePRD FOR DELAY 1 DAYNoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350007967NoneSD @ 3% - 27946337NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350007967None3% SD DEDUCTED - 27946337NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350008456NoneSD DEDUCTED 3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350008456NoneSD DEDUCTED 3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350008972NoneSD@3%None1000 VIMNoneInternet Pmnt-0013266161
0027946337/00010None8350009448NoneSD @ 3% 27946337NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350009448NoneISD 1%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350010026NoneSD 3% DEDUCTEDNoneVIMNoneInternet Pmnt-0013266161
0027946337/00010None8350012013NoneSD @ 3%NoneVIMNoneInternet Pmnt-0013266161
0028125386/00010None8350012164None3% SD DEDEUCTEDNoneVIM-0100NoneInternet Pmnt-0013266161
0027946337/00000None8350013101NoneSD @3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350014849NoneSD@3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350015263None3% SDNoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350016578NoneSD @3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350018625NoneSD@3%NoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350021238None27946337 SD2% OF RANoneVIMNoneInternet Pmnt-0013266161
0027946337/00000None8350021238NoneBALANCE SD 2% OF DELIVERED VALUE.NoneVIMNoneInternet Pmnt-0013266161
00030147None1000196NoneBG OF ENGG DEPTT-PO no. 29069706None0029069706/SEDENone45090IGL0002323
00501831None1000598NoneOK OPS DSONone0025860678/SEDENone36970IGL0000321
1680076238927None7800000453NoneSecurity DepositNoneNoneE-Pay. Portal
2416113750329None7800000666NoneSecurity DepositNoneNoneE-Pay. Portal
9448524949129None7800001020NoneSecurity Deposit for ILSD PONoneNoneE-Pay. Portal
2089441666736None7800001612NoneSD- WO NO.- 27655479NoneNoneE-Pay. Portal
1171None7800001778NoneDBP/HSE/GMS/2018/01TEN ID 2018_DLSO_76599_1None476None10103941
1173None7800002067NoneSECURITY DEPOSIT  KBP/GMS/AMC/2019-2022None22None0010103941
0025832065/00000None8350001355NoneSD 10% ON PO-25832065NoneCAPITAL PAYMENTSNoneInternet Pmnt-0010103941
0028797121/00000None8350018840NonePRD FOR DELAY 26 [email protected]%/WEEK,NoneVIMNoneInternet Pmnt-0010103941
0028781649/00000None8350018888NonePRD @ 0.5% FOR  5 WEEK DELAYNoneVIMNoneInternet Pmnt-0010103941
0028781649/00000None8350018888NoneSD DEDUCTION @ 10%NoneVIMNoneInternet Pmnt-0010103941
0028592385/00000None8350019048NonePBG @ 3%NoneVIMNoneInternet Pmnt-0010103941
0028592385/00000None8350019048NonePBG @ 3%NoneVIMNoneInternet Pmnt-0010103941
0028592385/00000None8350019548NoneSD @3% RS 59436 PO 28592385NoneVIMNoneInternet Pmnt-0010103941
0028797091/00000None8350021535None1520/- PRD EDNoneVIMNoneInternet Pmnt-0010103941
0028929860/00000None8350033680NonePRD FOR DELAY 9 [email protected]%/WEEK,NoneVIMNoneInternet Pmnt-0010103941
0028592385/00000None8350035918NoneSD3%NoneVIMNoneInternet Pmnt-0010103941
0026252796/00000None8350036049NonePO 26252796 SD@3%NoneVIMNoneInternet Pmnt-0010103941
0026252796/00000None8350044245NoneSD 3%NoneVIM-1100NoneInternet Pmnt-0010103941
0026252796/00000None8350044245NoneSD 3% INVOICED VALUENoneVIM-1100NoneInternet Pmnt-0010103941
0028012435/00000None8350044646NoneSD 3%NoneVIMNoneInternet Pmnt-0010103941
0029024599/00000None8350049750NonePRD FOR DELAYNoneVIMNoneInternet Pmnt-0010103941
  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Can you please add a column delimiter?

    • KuntalSingh's avatar
      KuntalSingh
      Helper V
      2 years ago

      Thanks Ibendlin

      I got the solution