Forum Discussion

JoHo_BI's avatar
JoHo_BI
Responsive Resident
9 years ago

DirectQuery hangs with the Today function

Hi all,

 

I have a very simple matrix which shows order numbers by client. I've added a custom column in the orders table to query whether the date is today, which is the following: 

 

_IsToday = IF(DATE(YEAR(Orders[DateCreated]),MONTH(Orders[DateCreated]),DAY(Orders[DateCreated])) = DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())), TRUE(),FALSE())

 

This works perfectly within the desktop software, but timesout and throws a resources available exceeded error while querying it on app.powerbi.com

 

Both the Power BI software and my browser are set to English (UK) locale.

 

If anyone can offer any insight, i'd be extremely grateful!

 

Thanks in advance,

Joe.

 

EDIT: I've also cleared the cache in the software and my browsers too.

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi JoHo_BI,

     

    I can't reproduce your issue, your formula works well on my side.  Can you ensure you have correctly configation the datasource?


    In addition, if you can please share some detail information about your issue, it will be help for troubleshooting.

     

    Regards,

    Xiaoxin Sheng

    • JoHo_BI's avatar
      JoHo_BI
      Responsive Resident
      9 years ago

      Hi Anonymous - Thanks for your reply, 

       

      Please find a link for a small test dataset available.

       

      Test Dataset

       

      In the top right, there is a "IsToday" filter, using the formula from the original post. It however does not load and still throws the error. 

       

      The datasource works perfectly, I can pull in data as you can see on the table on the left.