Forum Discussion
Anonymous
7 years agoNot applicable
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
- TeigeGaoSolution 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