Forum Discussion
Solved
calculating a date from an Active Directory value
Hoping someone can help.... I have a Excel spreadsheet connected to our active directory, which pushes out date values such 'Last login' as a power value (e.g. 1.32066E+17). In excel I had a for...
your formula is not the same, you subtract from the denominator in PowerBI, this one is just like in Excel
Last Login Date = DIVIDE ( [user.lastLogon], 8.64 * 10 ^ 11 ) - 109205
Thank you - spot on!!!