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
soo quick response and perfect. thanks buddy
one quick think here in community i can not add any .pbix file. can you tell me how you do that. when i drag and drop site sayd pbix file is not compatible
thanks
you are welcome.
i am not sure why you can't upload the pbix file. maybe you can create another post of this issue. Let's see if community support team can help you on this.
Hello,
will post a different for that.
the pbix file you just share me. i think u create second table which is static table and you take only value that has disc_type
the main table that i give is sale table so i just duplicate my sale table and remove other column and keep disc_type and invoice_no.
when when data refresh both sale and second sale table will refreah
so could you please duplicate the main table that i give you then just filter by disc_type?
create two table with following sample and then make relation. coz when data refresh both table will be refreshed. one got all columns another got only invoice_no and Disc_type column
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
the new table is not static table. It's a reference table
if the data in your table changed, it will change as well.