Forum Discussion
Solved
Gatwway Data Refresh
Hoping if some can tell me if this is the expected behaviour. The queries setup use the "Today" filter on the date column. This seems to be the only way to automatically retrieve the data for TODA...
You can consider adding a calculated column for tagging "Today" or not.
TodayOrNot = IF(Table[Date]=TODAY(),"Today","Not Today")
Then you can create a slicer with this column. Please refer to thread:
http://community.powerbi.com/t5/Desktop/Direct-Query-Today-Date-function/m-p/57208#M23337
Regards,
Thanks, good tip to know but they dont look to be supported by direct query ?
You can consider adding a calculated column for tagging "Today" or not.
TodayOrNot = IF(Table[Date]=TODAY(),"Today","Not Today")
Then you can create a slicer with this column. Please refer to thread:
http://community.powerbi.com/t5/Desktop/Direct-Query-Today-Date-function/m-p/57208#M23337
Regards,
Thank you :)