Forum Discussion
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
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
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