Forum Discussion
Sandeep13
3 years agoHelper III
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...
Ahmedx
3 years agoSuper User
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiHACZ_Smu67Qkufg?e=tdVPVU
Sandeep13
3 years agoHelper III
Hey While using your code i am getting error massage.
the query referenced calculated column which does not hold any data there is an error in its expression.
- Ahmedx3 years agoSuper User
Share sample pbix file to help you.
- Sandeep133 years agoHelper III
Hi Thanks for your reply.
For me I dont see attached option here becuase I am not a super user.
I have uploaded file in powerbi services. below is link for your refernce,.
Let me know if you are not able to open the link.
If possible share me your email id so i can give you persmission dirclty