Forum Discussion
2 reports showing different result from the same dataset
Hello Everybody,
I have a dataset with a table where there is a Time column (UTC)
I have created a calculated column to convert it in local time, which works perfectly (1st screenshot)
05:00 is converted in 07:00 (I'm in france 🙂 )
If a create a 2nd report based on the same dataset and cut/past my table, the result is différent and the time is not converted in local time.
I really don't understand.
Do you have any idea ?
Can i give you additionnal informations to help ?
3 Replies
- christinepayton
Most Valuable Professional
Could you post the DAX for the calculated column?
Here it is 🙂
It's a M formula.
DateTimeZone.ToLocal( DateTime.AddZone( #datetime(Date.Year([Period Start.Day]), Date.Month([Period Start.Day]), Date.Day([Period Start.Day]), Time.Hour([Period Start.Time]), Time.Minute([Period Start.Time]),Time.Second([Period Start.Time])),0) )- christinepayton
Hmm are you looking at both in the service? Or is one in desktop and one not? There's a thread here on timezone issues that may have something that applies: https://community.fabric.microsoft.com/t5/Service/Set-local-time-zone-Power-BI-Service/m-p/114120
