Forum Discussion
Calculating the difference in energy readings using difference in dates
Hi All, I have 3 columns. I wanna find the difference between the last and the first readings of "total_energy_generated_till" based on the timestamp of a day and based on the inverter ID. How do...
HI Kolumam
You can do it easily in Power BI if you weren't using Direct Query.
I can help with the T-SQL required to generate a view. Do you have a screenshot of the SQL Table? (Just the column names)
