Forum Discussion

Kolumam's avatar
Kolumam
Icon for Post Prodigy rankPost 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
Kolumam's avatar
Kolumam
Icon for Post Prodigy rankPost 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
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

  • Kolumam's avatar
    Kolumam
    Icon for Post Prodigy rankPost 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
      Icon for Microsoft Employee rankMicrosoft 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)

      • Kolumam's avatar
        Kolumam
        Icon for Post Prodigy rankPost Prodigy
        8 years ago

        Hi Phil_Seamark

         

        Please find my current table in SQL.