cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Need Flag for every unique value

Hi All,

I need your help in a logic. I need 1 in front of every unique count in query editor.

Here is the output which I need.

 ID Result 3381274 1 3381433 1 3381433 0 3381433 0 3381503 1 3381503 0 3381503 0 3382201 1 3382201 0 3382201 0 3382251 1 3382251 0 3382251 0 3382289 1 3382289 0 3382289 0 3382334 1 3382334 0 3382334 0 3383040 1 3383223 1 3383746 1 3384391 1 3384391 0 3384391 0 3384547 1 3384552 1 3384589 1

Thanks for your support as always.

Regards

Abhijit Mishra

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Need Flag for every unique value

Hi

1. Add a index column starting 0( You can do this in Query Editor -> Add columns tab -> index column-> from 0)

2. Create Rank_Flag column with the below formula:

Rank_Flag = IF(calculate(COUNTROWS(Table1),(FILTER(Table1, EARLIER(Table1[Index])>=Sheet4[Table1])),Table1[ID]=EARLIER(Table1[ID])) =1,1,0)

This will flag the first occurance of the ID . Hope this helps you.

Thanks
Raj

3 REPLIES 3
Super Contributor

## Re: Need Flag for every unique value

Hi

1. Add a index column starting 0( You can do this in Query Editor -> Add columns tab -> index column-> from 0)

2. Create Rank_Flag column with the below formula:

Rank_Flag = IF(calculate(COUNTROWS(Table1),(FILTER(Table1, EARLIER(Table1[Index])>=Sheet4[Table1])),Table1[ID]=EARLIER(Table1[ID])) =1,1,0)

This will flag the first occurance of the ID . Hope this helps you.

Thanks
Raj

Anonymous
Not applicable

## Re: Need Flag for every unique value

Hi @rajendran,

Is there a way I can do the second step in query editor also.

Regards

Abhijit

Super Contributor

## Re: Need Flag for every unique value

DAX measure is much faster and the calculations happens inmemoy. Is there any specific reason why you want to do this Query Editor?

Thanks
Raj

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!