Forum Discussion
DataVitalizer
Super User
Super UserRANKX missing values or redendant
Hi Community,
I have a table called "MyTable" with 3 columns (Category, SubCategory, Date)
I added a column using this DAX code to rank subcategories within each group by date:
MyRanking= R...
amitchandakSuper User
Super UserDataVitalizer , for column try like
MyRanking=
RANKX(FILTER((MyTable),
MyTable[Category] = EARLIER(MyTable[Category])
MyTable[SubCategory] = EARLIER(MyTable[SubCategory])
),
MyTable[Date],,asc,Dense)
For measure you can use new rank or rownumber
rank(DENSE,ALLSELECTED(MyTable[Category],MyTable[SubCategory],MyTable[Date]),ORDERBY([Date],asc))
add partitionBy if needed
DataVitalizerSuper User
Super UserThis time I had only one value for all subCategories "1"