I’ve always found that adding an index retains the sort order prior to removing duplicates and will work with larger datasets which you would not want to buffer - Nice to see sunny Brisbane out the window!
Thanks for the comment. In some situation I use the column I want to use for removing duplicate in a custom column and then used this new column for removing duplicate after sorting, but I didn't know adding index column can be used also. Yes, We are experiencing spring this days in Brisbane.
Hi Omid. I have a query which combines 6 different tables from web. 3 of them change once in month and 3 change everyday. Is there a way where I can make PQ skip loading static tables again and again?
Excellent analysis and resolution. Thanks for reporting, Omid.
You are welcome
Sizin videonuzu izleyene kadar yinelenenleri kaldırmadan önce indeks dizini ekleyip kaldırıyordum. Bu yöntem daha pratik. Teşekkürler.
You are welcome
I’ve always found that adding an index retains the sort order prior to removing duplicates and will work with larger datasets which you would not want to buffer - Nice to see sunny Brisbane out the window!
Thanks for the comment. In some situation I use the column I want to use for removing duplicate in a custom column and then used this new column for removing duplicate after sorting, but I didn't know adding index column can be used also.
Yes, We are experiencing spring this days in Brisbane.
Thank you for this information. Does Table.Buffer() prevent query folding when used this way?
Excellent tip :)
You are welcome
Sir need dax function in table
Hi Omid. I have a query which combines 6 different tables from web. 3 of them change once in month and 3 change everyday. Is there a way where I can make PQ skip loading static tables again and again?