Forum Discussion
Power BI : Rank based on date Month wise
Hi srajeshnkl
You could try adding the following two calcuated columns
MonthID = FORMAT('Table3'[Implemented date],"YYYYMM")Month = FORMAT(DATE( YEAR('Table3'[Implemented date]), MONTH('Table3'[Implemented date]), 1),"MMM YY")Make sure you hide MonthID and set Month to be sorted by MonthID
Then just drag the new Month column to the Column of a Matrix
Hi srajeshnkl,
Have you tried the solution provided by Phil_Seamark above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
Thanks for your help. This works fine.
Now I want d to generate a report like below, This report is in another table, I have already configured names in the new table, Corresponding ranks for the particular months to be copied to this new sheet as below, If rank not found in previous table then apply NA or last rank. How to achieve this ?
| Name | Jan | Feb |
| Sathish | 5 | 6 |
| Rajesh | 8 | 1 |
| Karthik | NA | NA |
| Visagan | 6 | 4 |
| Suganya | 1 | 6 |
| Vanitha | 2 | 10 |
| Sangeetha | 3 | 1 |
| Sahana | 10 | 6 |
| Ravikumar | 4 | 1 |
| Ramesh | 7 | 4 |
| Harini | 9 | 6 |
Microsoft EmployeeHi srajeshnkl
You could try adding the following two calcuated columns
MonthID = FORMAT('Table3'[Implemented date],"YYYYMM")Month = FORMAT(DATE(
YEAR('Table3'[Implemented date]),
MONTH('Table3'[Implemented date]),
1),"MMM YY")Make sure you hide MonthID and set Month to be sorted by MonthID
Then just drag the new Month column to the Column of a Matrix