Forum Discussion
Solved
Merging queries in Power Query, but values change after hitting "Close and Apply".
I have a view I made in SQL that uses lag to get the difference between the current row and the row before. The difference is the downtime in seconds a machine is down. I am looking at source_id of 1...
I ended up solving this in SQL. I did a self join and connected on two custom columns, HourMinute and DateOnly. This seems to work fine since each source_id has data coming in every minute. I can now bypass all the merging in Bi and the messed up downtime that happened after using Power Query.
villasenorbritt , seem like date is coming as number, change datatype to datetime
I'm working with downtime which is not really a "time", it is an integer that represents the seconds the machine was down. I use a duration measure to fix the formatting in my actual visuals. And the column to the left there is data, not date. I checked all my datatypes and all the dates/time columns are marked correctly.
Any other ideas?