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...
christinepayton
Most Valuable Professional
Most Valuable ProfessionalCould 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