Solved: Re: Need help on filtering value

KuntalSingh · ‎12-13-2023

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 Calculation.

Main sheet

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/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

Calculation sheet

PO No.

13266161

lbendlin · ‎12-19-2023

Can you please add a column delimiter?

View solution in original post

KuntalSingh · ‎12-19-2023

Thanks Ibendlin

I got the solution

View solution in original post

lbendlin · ‎12-16-2023

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-...

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/1447...

KuntalSingh · ‎12-17-2023

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