Forum Discussion
Need Help on create the Measure
Hello,rajendraongole1 ,thanks for your concern about this issue.
Your answer is excellent! And I would like to share some additional solutions below.
Hi,Anonymous .I am glad to help you.
If the calculated columns don't fit your needs, here is what I calculated by creating a measure, which enables dynamic transformations based on the data in the visual.
In fact I only modified the code rajendraongole1 provided by using RANK().
measure:M_Rank = VAR _rank= RANK(DENSE,FILTER(ALL(Rknk),'Rknk'[ID]=MAX('Rknk'[ID])),ORDERBY('Rknk'[Transaction Date],DESC),DEFAULT) RETURN _rankI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Hello,rajendraongole1 ,thanks for your concern about this issue.
Your answer is excellent! And I would like to share some additional solutions below.
Hi,Anonymous .I am glad to help you.
If the calculated columns don't fit your needs, here is what I calculated by creating a measure, which enables dynamic transformations based on the data in the visual.
In fact I only modified the code rajendraongole1 provided by using RANK().
measure:
M_Rank =
VAR _rank=
RANK(DENSE,FILTER(ALL(Rknk),'Rknk'[ID]=MAX('Rknk'[ID])),ORDERBY('Rknk'[Transaction Date],DESC),DEFAULT)
RETURN _rank
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Acutally as per rajendraongole1 I have done the calculated column and the measure as well added . it was worked well. Anonymous Thanks for your update regarding the measure. It's working well also.