Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
  • Shaurya's avatar
    Shaurya
    2 years ago

    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  

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for your help !

Shaurya's avatar
Shaurya
Memorable Member
2 years ago

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  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for your help !