needs
1 Topic
Converting SQL into DAX...
Hi, I have written the sql query below SELECT count(job_id) FROM (SELECT distinct job_id,status,DENSE_RANK over() partition by job_id order by timestamp desc AS rn FROM table1) t2 WHERE t2.rn = 1 and where t2.status = "PAUSED" to get the number of paused jobs by getting the latest status of the each job_id. I have duplicate values in the table, so I can't use LASTDATE and MAX also didn't work to get the correct result. Convert SQL query into DAX query for PowerBI visual - Stack Overflow this is my question posted in StackOverflow. the solutions I got don't meet my requirements 100% Just wondering if anyone knows how to convert that sql query to DAX. I'm doing this in direct query mode so there are some limitations as well.. thanks in advance!Solved7.9KViews1like29Comments