DAX query variable error in a flow

[Andy_W_UK]

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

[Shaurya · Accepted solution]

Hi @Andy_W_UK,

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  

[Shaurya · Accepted solution]

Hi @Andy_W_UK,

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  

[Andy_W_UK · Accepted solution]

Thanks for your help !