Forum Discussion
Power Bi service
I want the latest updated time of my data in powerbi desktop . To achieve this I have written down "date.localnow()" . when i published my report to power-bi service it is showing different tiings ....
Hi. If it's just one date, I have learn that is way easier to convert it to a different timezone adding or substracting hours than trying to change the default way of showing hours of power bi. You can easily change the date with a simple measure at the table running "date.localnow()". For example for UTC+1
DateTime Ireland UTC+1 = MAX(TableTypes[DateTime]) + 1/24
You can add or substract days for datetime, but if it's a decimal, then you can play with days. So 1/24 would be one hour.
I hope that helps to keep it simple.