Find unique values in a column

[Yashh]

hello all,

I want to find the unique value in the column when there are multiple data added with diffrerent revision number in it. How could i do it.?

Please help

[Greg_Deckler]

@Yashh You can possibly use DISTINCT for that but would need an example of your data to be certain. 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.