Forum Discussion
villasenorbritt
Resolver I
Resolver IMerging 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.
villasenorbrittResolver I
Resolver II 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.