Forum Discussion
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...
Can you please add a column delimiter?
Thanks Ibendlin
I got the solution
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
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 Can you please add a column delimiter?
Thanks Ibendlin
I got the solution