2 reports showing different result from the same dataset

[LcO_Fr]

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 ?

[christinepayton]

Could you post the DAX for the calculated column?

[LcO_Fr]

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