Convert Dax to tsql

Question

How to write following dax to tsql codeLike these answerhttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-stoptime-with-shift-in-DAX/m-p/3084809#M107736&nbsp;&nbsp;&nbsp;ResultTable =&nbsp;GROUPBY (&nbsp;&nbsp; &nbsp; GENERATE (&nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CROSSJOIN (&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALENDAR ( MIN ( InputTable[StartDate] ), MAX ( InputTable[FinishDate] ) ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GuidlineTable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Date", [Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Shift", [Shift],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "From", [From] + [Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "To", [To] + [Date]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; VAR T1 = FILTER ( InputTable, [StartDate] + [StartTime] &lt; [To] &amp;&amp; [FinishDate] + [FinishTime] &gt; [From] )&nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS ( T1, "Start", [StartDate] + [StartTime], "Finish", [FinishDate] + [FinishTime] )&nbsp; &nbsp; ),&nbsp; &nbsp; [Date],&nbsp; &nbsp; [Shift],&nbsp; &nbsp; "StopTime", SUMX ( CURRENTGROUP ( ), DATEDIFF ( MAX ( [From], [Start] ), MIN ( [To], [Finish] ), HOUR ) ))

smpa01 · Answer

I don't think the above DAX query is correct. Post a workbook here where it works

as9124141636 · Answer

Pbix file is in the answerhttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-stoptime-with-shift-in-DAX/m-p/3084809#M107736

Forum Discussion

Convert Dax to tsql

2 Replies

Related content

%%tsql magic in spark notebook

Convert DAX to M Code

Converter from PowerQuery to SQL or TSQL

Convert Text to number with DAX

Convert SQL into DAX