Forum Discussion
Wecks
7 years agoFrequent Visitor
Filter data by todays date
I am looking to sort data based on todays date. I created a column called Today that looks at the Entered date and if it equals today then it will show a 1 and if not a 0. Today = IF(EnteredDate[Date]=TODAY(),1,0) The issue is when I publish the report when the dataset refreshes this function sets all to 0. I am unsure as to why. I guess is there a way to filter a report table if it contains date values that = today?
This might be caused by UTC time zone. You may refer to the following post.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
1 Reply
- v-chuncz-msftCommunity Support
This might be caused by UTC time zone. You may refer to the following post.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337