Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all please how would I write this below statement in DAX, been trying to convert this SQL query but I keep getting an error
SQL Script
COALESCE(SUM(CASE WHEN ((CASE WHEN X THEN 1 ELSE 0 END
) = 0) AND (y is not null) THEN datediff(minute, x, x)* 1.0 / 60 ELSE NULL END), 0)
Any Recommendation will be much appreciated
Solved! Go to Solution.
@Janewhite , Correct the condition X<> 0
Sumx(Table, if( if([X] <>0, 1,0)=0 && not(isblank([Y])) , datediff([d1], [d2],minute)/60,blank()))
This should be a measure
@Janewhite , Correct the condition X<> 0
Sumx(Table, if( if([X] <>0, 1,0)=0 && not(isblank([Y])) , datediff([d1], [d2],minute)/60,blank()))
This should be a measure
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |