Forum Discussion
Converting SQL query to DAX
Scenario ::: I want to convert the SQL below to DAX , as you can see in SQL I am using ROW_Number windows function to partition by ssn and eomdate…to get the CostCenter associated with a SSN based ...
lbendlin
Super User
Super UserYou don't really need DAX for that. Take your data as is, and put it into a matrix visual. Set the value aggregation to Count Distinct of SSN. Done.