Forum Discussion
Running count unique flag
Hi Guys, I am new to PBI and need your help, I want to create a flag for unique workorder numbers, It is like creating a Rank for each Wonum. The senario and sample data below, Can you please hel...
Hi,
1. Add a index column from Edit queries tab
2. Add a Rank column
Rank = calculate(COUNTROWS(Table1),(FILTER(Table1, EARLIER(Table1[Index])>=Table1[Index])),Table1[Wonum]=EARLIER(Table1[Wonum]))
Replace Table1 as appropriate
I have opened Data View
created New Column from Modelling Tab. I have tried with Text data for Wonum And it is working fine.
Try to create the column with one filter on index and see if it works. Then add the second one.
Can I know what do you mean by "Replace Table1 as appropriate" please?
in the formula "Table1" should be replaced with the name of the Table used by you