https://community.fabric.microsoft.com/t5/Developer/Filter-data-by-todays-date/m-p/599878#M18212 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/99502">@Wecks</a>,</P> <P>&nbsp;</P> <P><SPAN>This might be caused by UTC time zone. You may refer to the following post.</SPAN></P> <P><SPAN><A title="" href="http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337" target="_blank">http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337</A></SPAN></P> Mon, 14 Jan 2019 07:41:19 GMT v-chuncz-msft 2019-01-14T07:41:19Z https://community.fabric.microsoft.com/t5/Developer/Filter-data-by-todays-date/m-p/599033#M18196 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? Fri, 11 Jan 2019 10:57:04 GMT https://community.fabric.microsoft.com/t5/Developer/Filter-data-by-todays-date/m-p/599033#M18196 Wecks 2019-01-11T10:57:04Z https://community.fabric.microsoft.com/t5/Developer/Filter-data-by-todays-date/m-p/599878#M18212 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/99502">@Wecks</a>,</P> <P>&nbsp;</P> <P><SPAN>This might be caused by UTC time zone. You may refer to the following post.</SPAN></P> <P><SPAN><A title="" href="http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337" target="_blank">http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337</A></SPAN></P> Mon, 14 Jan 2019 07:41:19 GMT https://community.fabric.microsoft.com/t5/Developer/Filter-data-by-todays-date/m-p/599878#M18212 v-chuncz-msft 2019-01-14T07:41:19Z