Forum Discussion

JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive 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 =...
Need Help
JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive 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. 

JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
9 years ago

Still very much need help!

    • JoHo_BI's avatar
      JoHo_BI
      Icon for Responsive Resident rankResponsive Resident
      9 years ago

      Hi Anonymous,

       

      The table I am drawing from contains approx. 400k rows before I apply the table filters. After the filters, it goes to 886 rows, but still doesn't pull through the data unfortunately.

       

      I see your report works, however IsToday always returns false. If it were to return at least 1 true record, i'm not sure it would load. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi JoHo_BI,

         

        >>The table I am drawing from contains approx. 400k rows before I apply the table filters.

        Perhaps you can try to use value function to create a new table with the value of "istoday" column, create the relationship to original table and use the new table as the source of slicer.

         

        Regards,

        Xiaoxin Sheng