DAX flag the first occurrence

[sabd80]

Hi,
I have below data, I would like to create a calculated column (Rank) to flag only one record with 1 for a supplier that have multiple lines with the same date.
for example, supplier 12345 has 9 records, I want to flag only one record with 1.
Can you please help.

[tharunkumarRTK · Accepted solution]

Hi @sabd80 

You can achieve this by creating an index column, Hope the below pattern fullfuils your requirement

P.S. calculated columns can degrade your report performance. 

If my answer fulfills your requirement then please mark my post as solution.

Thanks

Tharun

[Ahmedx]

if the supplier has the same dates, then only in power query you can do this

[sabd80]

@Ahmedx , Thanks for your solution.
I need the other records, so I can't remove them, plus I have a huge data all these transformation will affect the performance of the report.

[Ahmedx]

to do this remove the last two steps
and then you will be able to work with the data and filter it using DAX

[amitchandak]

@sabd80 , You create a measure using new rownumber function

ROWNUMBER(ALLSELECTED(Table[supplier id], Table[Date]),ORDERBY([Date],DESC),LAST,partitionBy(Table[supplier id]) )

Power BI - New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1

[sabd80]

this one is not working, it return 1 for all the 9 records.