Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to make the RangeStart filtering directly in the query and I need help to refer to the RangeStart parameter in the query in advanced editor.
my original query says: -- where ( task0.createdonutc >= '20191231 23:00:00' --
I am trying: -- where ( task0.createdonutc >= #"RangeStart" --
or -- where ( task0.createdonutc >= RangeStart -- //and I get an error: Invalid column name 'RangeStart'
The format of my RangeStart is 01-01-2020 00:00:00
How can I refer to RangeStart (which is Date time too) in the query?
Thank you in advance
Solved! Go to Solution.
@setis , In power query for me it is working like
each [task0.createdonutc] >= RangeStart
@setis , In power query for me it is working like
each [task0.createdonutc] >= RangeStart
@amitchandak thanks,
I'm looking for a way to place it in the advance editor inside the query, not as an extra step. Do you know how to do that?