cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
XTF_2020
Helper I
Helper I

Rank by category and by date

Hello everyone


How can I make a column calculated by category and by date?

 

DateCategoryOrder
2020-08-01A1
2020-08-03A3
2020-08-03A3
2020-08-02A2
2020-08-04A4
2020-08-25B4
2020-08-03B1
2020-08-10B2
2020-08-10B2
2020-08-24B3
2020-08-21C4
2020-08-08C2
2020-08-02C1
2020-08-14C3

 

I would like to create a column to classify and sort each category by date.It's possible?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@XTF_2020 ,

Check if you need a new column like this

Rank = RANKX(FILTER((RankTable), RankTable[Category]=EARLIER(RankTable[Category])),[Date],,asc,Dense)

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@XTF_2020 ,

Check if you need a new column like this

Rank = RANKX(FILTER((RankTable), RankTable[Category]=EARLIER(RankTable[Category])),[Date],,asc,Dense)

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

VijayP
Super User
Super User

@XTF_2020

Is this the outcome do you require. Please let me know!

 

2020-09-18_194808.png




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.