RANK Based on Date within a Group using a DAX measure

Anonymous — Wed, 07 Oct 2020 14:52:14 GMT

Good evening,

I have tried several things for ranking based on Date within group since there is a very large number of posts covering this issue.

Most answers though suggest the creation of a calulated column. Nevertheless, I am able to create measures only since the data source I am connecting to is a Tabular Analysis Services model, so I am not allowed to create a calculated column in Power BI.

Also, I have to create it in PowerBI since its calculation is dependent on slicer's selected value.

The business question is "Give me the latest available for each group during the period that is selected through the slicer".

EDIT:

Initial Data

ID	GROUPCODE	CREATEDDATE
11050	A	6/10/2020
11056	B	6/10/2020
11026	B	6/10/2020
10481	A	30/7/2020
10469	A	27/7/2020
11023	C	6/10/2020
10601	C	3/9/2020
10142	C	30/6/2020

DESIRED OUTPUT

ID	GROUPCODE	CREATEDDATE	Rank
11050	A	6/10/2020	3
11056	B	6/10/2020	1
11026	B	6/10/2020	1
10481	A	30/7/2020	2
10469	A	27/7/2020	1
11023	C	6/10/2020	3
10601	C	3/9/2020	2
10142	C	30/6/2020	1

Is there any solution to my problem?

Thank you in advance.

Re: RANK Based on Date within a Group using a DAX measure

DataInsights — Tue, 06 Oct 2020 22:36:45 GMT

Anonymous, would you be able to provide sample data and a screenshot of the desired output?

Re: RANK Based on Date within a Group using a DAX measure

Anonymous — Wed, 07 Oct 2020 14:53:20 GMT

I have provided the requested details inside my initial post.

topic Re: RANK Based on Date within a Group using a DAX measure in DAX Commands and Tips

RANK Based on Date within a Group using a DAX measure

Re: RANK Based on Date within a Group using a DAX measure

Re: RANK Based on Date within a Group using a DAX measure