Forum Discussion
Running count unique flag
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.
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
Hi, I have created Index column, But when I try to creaate a measure it throws me an below error,
"EARLIER/EARLIEST refers to an earlier row context which doesn't exist."
I tried to create Custom Column in edit quieries but again it throws below error
"Expression.Error: The name 'CALCULATE' wasn't recognized. Make sure it's spelled correctly."
I tried to create New Column and it throws me below error
"DAX don't support comparing values of type integer with values type of text..."
Can you let me know what I am doing wrong please, I also tried to use format without much success
My WONUM is text data type... It will be like MJ12345, I tried to change the data type but it still throws the same error
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.