Forum Discussion
DAX query variable error in a flow
Hello everyone,
I am a novice to DAX so hope someone can point me in the right direction please.
I have a flow which queries a dataset and then goes on to send the result as an email attachment.
I copied the query from Performance analyzer in desktop - it queries a table using a date parameter of "today".
In the flow I found that I need to change the DAX query to set a new variable of today's date and then use this rather than a specific date but the format I have tried returns a format error so I would really appreciate it if someone could help me out.
// DAX Query
DEFINE
VAR _TodaysDate = DateTimeZone.UtcNow()
VAR __DS0FilterTable4 =
FILTER(
KEEPFILTERS(VALUES('SDT Clarity Tasks'[ETD])),
AND(
'SDT Clarity Tasks'[ETD] = '_TodaysDate')
Many thanks !
Andy
Hi Anonymous,
Try this:
DEFINE VAR _TodaysDate = TODAY() VAR __DS0FilterTable4 = FILTER( KEEPFILTERS(VALUES('SDT Clarity Tasks'[ETD])), 'SDT Clarity Tasks'[ETD] = _TodaysDate )Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
2 Replies
Hi Anonymous,
Try this:
DEFINE VAR _TodaysDate = TODAY() VAR __DS0FilterTable4 = FILTER( KEEPFILTERS(VALUES('SDT Clarity Tasks'[ETD])), 'SDT Clarity Tasks'[ETD] = _TodaysDate )Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI