Power BI DISTINCT table or column function

This is a short video on how to use the distinct function in power bi.
With the help of an example, i have demonstrated on how to use distinct function by taking either column or entire table as reference.
Other Videos which you might be interested:

[gokulnathpl]

I am having duplicates in the Table range as well as in the main table, If I do merge query it gives extra records for the each main table records. I want the first value, as gives in excel. Is that possible in Power BI?

[vaibhavsaxena]

Sample Column = DISTINCT(
SELECTCOLUMNS(
'TABLE NAME ',
"COLUMN 1 NAME", [COLUMN 1 NAME ],
"COLUMN 2 NAME", [COLUMN 2 NAME]
)
)