Forum Discussion
Solved
hi
Hello, i have a very silly issue i want to see following both line of entry in power bi if i filter by BG0000117 then i can see only that line of entry but i dont want to use filte...
after you move columns and null value, then you need to remove duplicates.
Hello ryan_mayu ,
I tried removing the filter but cant resolved,
I have changed the permission access to the folder.
Please try now. just click the link and you be able to download pbix and xlxs file with sameple data. please inform me if have any issues.
If you still cant get access please share your email address (if possible) so i can email you
https://drive.google.com/drive/folders/1-WQ9JQ36Rb0VqprPY6cGoWHxepdamidg?usp=sharing
thanks
Hello
Thanks for your reply. would mind to help me with a pbi file with this sample data
| INVOICE_NO | INVOICE_DT | USER_BARCODE | Retail_Price | SQTY | DISC_TYPE | Return | Amount | Store |
| 223050600020 | 06-05-23 | 36002 | 214 | 1 | 0 | 214 | 100010049 | |
| 223050600020 | 06-05-23 | 36002 | 0 | 1 | BG0000117 | 0 | 0 | 100010049 |
| CR02230500010 | 06-05-23 | 36002 | 214 | 0 | 1 | 0 | 100010049 | |
| 223050600022 | 06-05-23 | 36002 | 214 | 1 | 0 | 214 | 100010049 | |
| 223050600022 | 06-05-23 | 36002 | 0 | 1 | BG0000117 | 0 | 0 | 100010049 |
| 223051000002 | 10-05-23 | 36002 | 292.29 | 10 | 0 | 2922.9 | 100010049 | |
| CR02230500019 | 10-05-23 | 36002 | 292.29 | 0 | 10 | 0 | 100010049 | |
| 223051000004 | 10-05-23 | 36002 | 292.29 | 10 | 0 | 2922.9 | 100010049 | |
| 323051000004 | 10-05-23 | 36002 | 292.29 | 8 | 0 | 2338.32 | 100010049 | |
| 223051000054 | 10-05-23 | 36002 | 213.75 | 12 | 0 | 2565 | 100010049 | |
| 223051000067 | 10-05-23 | 36002 | 292.29 | 8 | 0 | 2338.32 | 100010049 | |
| 223051000071 | 10-05-23 | 36002 | 236.25 | 6 | 0 | 1417.5 | 100010049 | |
| 223051000086 | 10-05-23 | 36002 | 213.75 | 6 | 0 | 1282.5 | 100010049 | |
| 223051000089 | 10-05-23 | 36002 | 214 | 1 | 0 | 214 | 100010049 | |
| 223051000089 | 10-05-23 | 36002 | 0 | 1 | BG0000117 | 0 | 0 | 100010049 |
| 323051100011 | 11-05-23 | 36002 | 292.29 | 8 | 0 | 2338.32 | 100010049 | |
| 223051100068 | 11-05-23 | 36002 | 236.25 | 3 | 0 | 708.75 | 100010049 | |
| 223051100084 | 11-05-23 | 36002 | 214 | 1 | 0 | 214 | 100010049 | |
| 223051100084 | 11-05-23 | 36002 | 0 | 1 | BG0000117 | 0 | 0 | 100010049 |
| 223051500088 | 15-05-23 | 36002 | 273.92 | 1 | 0 | 0 | 100010049 | |
| 423051500005 | 15-05-23 | 36002 | 214 | 3 | 0 | 642 | 100010049 | |
| 423051500005 | 15-05-23 | 36002 | 0 | 3 | BG0000117 | 0 | 0 | 100010049 |
| 223051700023 | 17-05-23 | 36002 | 236.25 | 12 | 0 | 2835 | 100010049 | |
| 323051700019 | 17-05-23 | 36002 | 0 | 1 | BG0000117 | 0 | 0 | 100010049 |
Thanks
what's the expected output?
do you want to show below invoice?
223050600020
223050600022
223051000089
223051100084
423051500005
323051700019