Calculating the difference in energy readings using difference in dates

[Kolumam]

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 I acheive this ?

[Ashish_Mathur]

Hi,

Share the PBI file.  Please also show the expected result there.

[Phil_Seamark]

Hi @Kolumam

This calculated table gets pretty close.  Just change where I have 'Table'

New Table = SUMMARIZE(
                ADDCOLUMNS(
                    'Table',
                    "Date",DATEVALUE(FORMAT('Table'[Tstamp],"YYYY-MM-DD"))
                    ),
                [Date],
                [InverterID],
                "myMin",MIN('Table'[total_energy_generated_til]),
                "myMax",MAX('Table'[total_energy_generated_til]),
                "Diff",MAX('Table'[total_energy_generated_til]) - MIN('Table'[total_energy_generated_til])
                )

[Kolumam]

Hi @Phil_Seamark

I am using DirectQuery and I am not able to create a new table. Any suggestions please ?

[Phil_Seamark]

What is your direct query datasource?  Is it an SQL datasource?

[Kolumam]

Yes 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]

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)

[Kolumam]

Hi @Phil_Seamark

Please find my current table in SQL.