Forum Discussion
convert sql statement into DAX
How to convert the below sql statement into DAX to calculate Average Lag? Thanks SELECT avg(isnull(datediff(day, b.ClaimSubmitDate, t.PostDate),0)) as AvgLag FROM [dbo].[Bill] b join [dbo].[Tr...
Honestly, any question that starts with "I want to convert this SQL into DAX" generally never go well when all you present is the SQL. Sample data and expected result will get you there quicker. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490