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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
KuntalSingh
Helper V
Helper V

Need help on filtering value

‎12-13-2023 01:57 AM

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

 

Labels:
Message 1 of 5
1,399 Views
0
2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User
In response to KuntalSingh

‎12-19-2023 04:15 PM

Can you please add a column delimiter?

View solution in original post

Message 4 of 5
1,284 Views
KuntalSingh
Helper V
Helper V
In response to lbendlin

‎12-19-2023 11:32 PM

Thanks Ibendlin

I got the solution

View solution in original post

Message 5 of 5
1,267 Views
4 REPLIES 4
lbendlin
Super User
Super User

‎12-16-2023 05:02 PM

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

Message 2 of 5
1,344 Views
0
KuntalSingh
Helper V
Helper V
In response to lbendlin

‎12-17-2023 08:32 PM

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 DAY@.5%/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 DAY@.5%/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
Message 3 of 5
1,314 Views
0
lbendlin
Super User
Super User
In response to KuntalSingh

‎12-19-2023 04:15 PM

Can you please add a column delimiter?

Message 4 of 5
1,285 Views
KuntalSingh
Helper V
Helper V
In response to lbendlin

‎12-19-2023 11:32 PM

Thanks Ibendlin

I got the solution

Message 5 of 5
1,268 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All