Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

Date measure not updating in App - OK in desktop

Hi all, 

 

Wrote a measure as a "welcome" message to users, it should greet them with Good morning/afternoon/evening as appropriate - depending on the time of day. 

 

It works absolutely fine in desktop and changed from afternoon to evening at 18.00 today, but it doesnt seem to be carrying over to App. Tried refresh obviously, not having it. Desktop says evening as its 18.30, App says Afternoon as I wrote it at 4pm. 

 

What am i missing? Anything obvious? The measure itself seems fine. Every other data set and measure updates OK as far as I can see. Workspace has had both a scheduled and manual refresh in that time. 

 

Here is the measure: 

 

Welcome Text = VAR Hour = HOUR(NOW()) VAR Greeting = SWITCH(TRUE(),
Hour >= 0 && Hour < 5, "Good Night",
Hour >= 5 && Hour < 12, "Good Morning",
Hour >= 12 && Hour < 18, "Good Afternoon",
Hour >= 18 && Hour < 24, "Good Evening") RETURN Greeting & " " & "& Welcome to XYZ Dashboard"

 

 

 

 

1 ACCEPTED SOLUTION
rodrigosan
Resolver III
Resolver III

Hello.
To view the PBI Service you must match the server's time zone.
In my case I'm in Brazil, so I need to go back 3 hours in decimal in the measure 0.125
And it will look like this:

rodrigosan_0-1657130492115.png

 

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

View solution in original post

4 REPLIES 4
rodrigosan
Resolver III
Resolver III

I understand that yes, it should.
Do a test using this model I made and see the result.
I think this way you can find the time difference


Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

I will keep trying to work out the time difference but yes your measure works - thank you! 

rodrigosan
Resolver III
Resolver III

Hello.
To view the PBI Service you must match the server's time zone.
In my case I'm in Brazil, so I need to go back 3 hours in decimal in the measure 0.125
And it will look like this:

rodrigosan_0-1657130492115.png

 

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

Thank you yes this makes sense and it does fix it in theory. 

I am located in UTC region so I expected them to be the same as I understood service app worked off of UTC? 

 

When I have tried changing the measure to random numbers it does change but I cannot work out which way it is going - its been a long day! 

 

If I'm based in UTC should it not just marry up? 

 

Thanks! 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.