Forum Discussion
hi
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
maybe you can try to create a dim table which contains two columns
BG0000117 and data in first column
then you create relationship between two tables.
when you filter BG000017 in the dim table. you can see two lines of your original table
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