Forum Discussion
Rank function Based on ReportedDate like YYYYMM
Hi All, I have 2 columns reporting_mth and Amount, I want to create rank based on reporting_mth and sort data based on amount. Now If you see i have 202203 and 202212 in my data. I am expecti...
Order =
VAR _t = LEFT( MAX( [reporting_mth],4))
RETURN
RANKX(
FILTER(ALL('Table'),
LEFT('Table'[reporting_mth],4)=_t),
[reporting_mth],,DESC)
Still some issue.
I am Passing dax in measure.
Getting below errro msg.
A single value for column 'reporting_mth' in table 'Port_Append' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.