Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

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...
General Comment
Need Help
Show and Tell
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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's avatar
Kolumam
Post Prodigy
8 years ago

Hi Phil_Seamark

 

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

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

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

    • Kolumam's avatar
      Kolumam
      Post Prodigy
      8 years ago

      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's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        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)