Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

JSON datetime conversion in power query

Hi,   I am looking for 2 clear solutions.   1. Query for JSON string datetime conversion to datetime in PBI.   2. Can a ONE query be executed to convert multiple columns that are currently in J...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi lbendlin dax 

 

Correct its ISO-8601

 

attached Screen shot of the data presented in Power BI

 

1592715600000

Equates to

06/21/2020 15:000:00

MM/DD/YYYY HRS:MIN:SEC

 

iv applied a few different queries but no luck as yet.