Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
After trying for a number of times finally was able to use RANKX for direct query data. Do let me know if you are stuck up with this. Happy to help !
Solved! Go to Solution.
Hi @tsmehta,
Current power bi has limited most of the Dax function used to create calculated columns or tables if you are working on direct query mode. I'd like to suggest you create a measure expression instead.
Regards,
Xiaoxin Sheng
Hi @tsmehta,
Current power bi has limited most of the Dax function used to create calculated columns or tables if you are working on direct query mode. I'd like to suggest you create a measure expression instead.
Regards,
Xiaoxin Sheng