Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dax formula Help

Can any one convert sql query into dax please,

 

SELECT SUM(
CASE
WHEN vis.CODTYPSUR = par.valpar and vis.CODSTA= 5 THEN
1
ELSE
0
END
) ND,
vis.CODD

FROM dbo.TA vis
INNER JOIN (
SELECT CODD
,VALPAR
FROM dbo.T0
WHERE codpar = 'DE'
) par ON (vis.CODD = par.CODD)

WHERE vis.flgann = 0 and vis.CODSTA in (5,6)

GROUP BY vis.CODD

 

Thanks in advance

1 Reply

  • TeigeGao's avatar
    TeigeGao
    Solution Sage

    Hi Anonymous ,

    Could you please share some sample data to us for analysis? We need to know the schema of tables.

    Best Regards,

    Teige