Forum Discussion

pbi_besi's avatar
pbi_besi
New Member
2 years ago
Solved

Query within Power Automate

Hi, I have used a Power BI query within Power Automate with the Power Automate step "Run a query against a dataset". Now, I want to make the date specification dynamic so that today's date is always...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hii, once try this

    FILTER( KEEPFILTERS(VALUES('Mail'[DateTimeReceived])), AND( 'Mail'[DateTimeReceived] >= ToString(utcNow(), "yyyy-MM-dd"), 'Mail'[DateTimeReceived] <= ToString(utcNow() + DateDiff(DAY, 1), "yyyy-MM-dd") ) )

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hii, once try this

FILTER( KEEPFILTERS(VALUES('Mail'[DateTimeReceived])), AND( 'Mail'[DateTimeReceived] >= ToString(utcNow(), "yyyy-MM-dd"), 'Mail'[DateTimeReceived] <= ToString(utcNow() + DateDiff(DAY, 1), "yyyy-MM-dd") ) )