How to Import .json Data into Power BI & Create New Columns with DAX
This video is the second part of a series, where we collect data from Movesense sensor and analyze it in Power BI.
DAX formulas used in this exercise:
Timestamp_seconds = ('Day1'[Timestamp]/1000) - 70
Duration = TIME(0, 0, Day1[Timestamp_seconds])
You can find the .json files for this exercise in GitHub: https://github.com/DC-and-beyond/Move...