Forum Discussion

Drlazor's avatar
Drlazor
Frequent Visitor
2 years ago

Remove all non-distinct values using a Direct Query model.

I have a dataset that has been set up in Azure Analytics services to try and optimize the speed of the dashboard. However, I would like to try and remove all non-distinct values from a column in the ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

And why would A-Beta-Charlie be preferred to A-Beta-Delta ?

Drlazor's avatar
Drlazor
Frequent Visitor
2 years ago

I would like to keep the 1st instance of column A.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Power BI does not have a concept of that.  You need to bring your own sort order.