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.
Hi @Anonymous
I can reproduce your problem.
To slove this, create a measure to show my local time
now = UTCNOW()+8/24
(my timezone is UTC+8)
Then publish to Service, it shows correctly.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
If you want to identify which invoice date is equal to the current datetime of your local time, you could create a measure
Measure = VAR DATETIME = FORMAT ( MAX ( [invoice date] ), "mm/dd/yyyy hh:mm" ) VAR _now = FORMAT ( NOW (), "mm/dd/yyyy hh:mm" ) RETURN IF ( DATETIME = _now, 1,0)
If you want to display the current datetime in a card visual, please create a measure
Measure 2 = NOW()
Add it in the card visual, or use format function to format it to get expected format.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi thank you so much for your help, I do seems to have a problem in power BI it shows the current date & time correctly now. but when i published it and live it it show different timings already.
here's the sample:
below is the correct timing in BI:
but when i published it to live its different timing:
wanted the outcome to be the same current timing. How do i do it? Thank you so much!
Hi @Anonymous
I can reproduce your problem.
To slove this, create a measure to show my local time
now = UTCNOW()+8/24
(my timezone is UTC+8)
Then publish to Service, it shows correctly.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Please see the below Examples.
Measure = VAR _date_time = FORMAT( NOW(), "mm/dd/yyyy hh:mm:ss" ) -- format returns text VAR _time = FORMAT( NOW(), "mm/dd/yyyy hh:mm:ss" ) -- format returns text VAR _date = FORMAT( NOW(), "mm/dd/yyyy" ) -- format returns text VAR _t = NOW() -- date time as original format
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.