how to create a card to show specific datetime

[Jeanxyz]

Hi,

I have created a card to show the time the report is lastly refreshed. As the data is refreshed by gateway at 11 am everyday, I have written a measure as below

Last Refresh Date = if(utcnow<= today() + time(11,0,0),

today()-1+time(11,0,0),

today()+time(11,0,0))

I got an error message. Thanks for help.

[ryan_mayu · Accepted solution]

@Jeanxyz 

maybe try add brakets after utcnow

Last Refresh Date = if(utcnow()<= today() + time(11,0,0),

today()-1+time(11,0,0),

today()+time(11,0,0))

[ryan_mayu · Accepted solution]

@Jeanxyz 

maybe try add brakets after utcnow

Last Refresh Date = if(utcnow()<= today() + time(11,0,0),

today()-1+time(11,0,0),

today()+time(11,0,0))

[Jeanxyz]

Thank you! It works!

When I try to add this measure to a card, it shows output in date format, instead of datetime format. How can I fix this? I tried to set format as datatime general pattern in the modeling view, but it doesn't give me the format expected.

[ryan_mayu]

@Jeanxyz 

try to change a format which displays date and time.

[Jeanxyz]

How do you get the datetime format in the dropdown list? I don't find it on my screen.

[ryan_mayu · Accepted solution]

@Jeanxyz 

it's under the measure tool

are you using the latest pbi version?