Forum Discussion
Helper IDateDiff shows different result in Desktop vs web
Hi Guys,
I've got a field within a table that stores the date/time a record was created. This is stored in the UK setting - I.e: 24/04/2020 09:15.
I have another field that has a measure applied which calculates the days since the date shown and stores a numerical value -
5 Replies
- az38
Community Champion
Hi mattsampson
it is regional settings and localization issue.
your 01/05/2020 13:45 could be interpreted as 5 Jan or 1st of May in diffrent localizations
mattsampsonHi az38,
Could you point me in the right direction to set that?
In the desktop options for the current file ->Regional Settings -> English (United Kingdom).
I can add ?language=en-GB on the end of the URL string which shows the dates fields correctly, but the measure obviously doesn't update. Is there a setting within the PBX file I'm missing or something within the dataset?
Thanks
- az38
unfortunately I cannot to find strong and guaranteed solution with settings for myself.
Usually, I have to use some DAX DATE() or Power query #datetime() using workaround
V-lianl-msftCommunity Support
Hi mattsampson ,
Is this problem sloved?
If not, please let me know.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- V-lianl-msft
Hi mattsampson ,
You can refer to these two blogs to learn more about power Bi time zone issues:https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
