Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I have following issue in PBI desktop (April release) : when creating calculated column using a date and time column, the result is one day off.
When using the same data source in PowerPivot Excel, using the same formula, the result is as expected.
E.g.
Date field reads : April 12, 2017 12 AM
Time field reads: 1/1/1900 1 AM
when adding both in PBI, result becomes April 13 1AM
in Excel April 12 1AM (which is the correct result)
Anybody any idea how to solve this, because a lot of my calculations depend on having correct timestamps.
thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.