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.
Hello Comunity,
Actuall i have the challange whit Power Query. I will create a IF-Function.
Example: if [Start]>20:00 and [End]<21:00 then [End]-[Start] else 0
But i become a error message. The Question is, we can i do that?
Greetings,
Simon
Solved! Go to Solution.
Hi @Simon_Braun
Your code would like this:
[Start]>#time(20, 00, 0) and [End]<#time(21, 00, 0)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Hi @Simon_Braun
Your code would like this:
[Start]>#time(20, 00, 0) and [End]<#time(21, 00, 0)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
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.