DAX Calendar publish to Power BI portal service not show today date

[Anonymous]

I use DAX:  CALENDAR (DATE(2021,6,1), TODAY()) to filter today's data.

However, when I publish to Power BI portal service. And define the referesh data schedule at 6:30 AM Beijing Time China.

It doesn't get the right date, for example, today is Jun 1 st, the DAX still is May 31.

It is around 10:00 am, it change to the right date (Jun 1st).

Anything wrong?

Thanks!

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

It might be a time difference issue.

The Power BI Service uses UTC time.

The solution is to add the corresponding time difference to the datetime column on your calendar table.

new datetime = [datetime]+hours/24

Best Regards,

Jay