Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kivancc94
Helper I
Helper I

INDEX function error

Hi,

I wanted to try new Dax function INDEX. But I received an error. What could be the reason ?

Data;

kivancc94_0-1683220708627.png

 

 

I wanted to create a new table with one row which includes highest profit. But "Relation parameter may have duplicate rows." error occured.

kivancc94_1-1683220800988.png



Thanks a lot in advance. 

1 REPLY 1
Kannan_n
Helper I
Helper I

Hi @kivancc94

The syntax for writing DISTINCT (Column) Function:

 

DISTINCT(<column>)

 

Where,

 

Column- It is a column from which unique values are to be returned.

 

Ex. DISTINCT([ProductPrice])

 

It returns the unique values from the column ‘Prod uctPrice’.

 

If this resolve the problem please give a like and make the question as resolve 

Thanks and Regards 

Kannan.N 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.