DAX Weekday Name using UTC or UTCNOW

[sureshsonti]

I used this formula to get weekday name and it works in Power BI Deskop.
WEEKDAY_TODAY'S DAY = UPPER(FORMAT(TODAY(), "dddd"))

When I publish the report on Power BI Services the weekday name changes to the next day at 6:00 PM in the evening. I live in Louisiana Central Time

Example: The Power BI Desktop shows TUESDAY but Power BI Services shows WEDNESDAY after 6:00 PM

Expected Result: I want to see TUESDAY on both Power BI Desktop and Power BI Services till 11:59 PM

I read some articles on UTC and found this. UTC is 6 hours ahead and thats why Power BI Services is showing Wednesday even though it is still Tuesday. Hope this makes sense

https://www.worldtimebuddy.com/utc-to-united-states-louisiana-baton-rouge

Thanks for your help

 

[GraH - Guido]

Isn't that a server setting somewhere that can be adjusted?

EDIT: it seems not, but workarounds via Power Query are the woy to go it seems:
http://radacad.com/solving-dax-time-zone-issue-in-power-bi

 

[Chihiro]

@sureshsonti
If I recall, you use direct query to SQL for your data set.
In such case easiest method is to use native query language in PQ.
Simply query using "Select getdate() as CurDate" this will return current date of your SQL server.
Use the resulting table in your Dax measure.

 

[sureshsonti]

@sureshsonti
If I recall, you use direct query to SQL for your data set.
In such case easiest method is to use native query language in PQ.
Simply query using "Select getdate() as CurDate" this will return current date of your SQL server.
Use the resulting table in your Dax measure.

ChiHiro,
You method seems to be working. I published the report on Power BI services and it shows the current day and current time. I will let you know what happens after 6:00 PM today. Thanks for your suggestion.