Reply
Frequent Visitor
Posts: 10
Registered: ‎12-20-2018
Accepted Solution

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?

Accepted Solutions
Community Support Team
Posts: 3,819
Registered: ‎07-09-2016

Re: Filter data by todays date

@Wecks,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 3,819
Registered: ‎07-09-2016

Re: Filter data by todays date

@Wecks,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.