Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need to convert this DAX query to SQL

Can anyone let me know how to convert Need to convert this DAX query to SQL   > 2% Net Outflows = IF(COUNTROWS(FILTER('Fund Flow','Fund Flow'[NET_PERCENT_1D] < -0.02)) = 0,BLANK(),COUNTROWS(FIL...
Tips and Tricks
Legend_11's avatar
Legend_11
Icon for Resolver I rankResolver I
3 years ago

select colum1,col2,
CASE
WHEN (
SELECT COUNT(*)
FROM FundFlow
WHERE NET_PERCENT_1D < -0.02
) = 0 THEN NULL
ELSE (
SELECT COUNT(*)
FROM FundFlow
WHERE NET_PERCENT_1D < -0.02
)
END AS Result from table