Forum Discussion
Kolumam
Post Prodigy
Post ProdigyCalculating 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...
KolumamPost Prodigy
Post ProdigyYes that's right. It is from SQL. I just imported the VIEW from SQL to Power BI. Since I am not good at SQL, I thought of implementing in Power BI. Could you help me ?
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHI 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)
- Kolumam