Forum Discussion
translating SQL to DAX in DirectQuery Mode
What does the SQL query below translate to in DAX? SELECT
COUNT(dbo.tblUserUpload.Id) AS theCount
FROM
dbo.tblLoanStatus INNER JOIN
dbo.tblLoanStatus AS tblLoanStatus_CM ON dbo.tblLoanStatus.CM_...
Hi yvese,
Is srinivt's suggestion helpful to your scenario? If so, would you please mark the helpful reply as an answer? If not, please provide sample data in tblLoanStatus and tblUserUpload and make table structure more clear. Also, please post a screenshot of the result returned by above SQL Query so that we can understand your expected output.
Regards,
Yuliana Gu