Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Hi,
Share the PBI file. Please also show the expected result there.
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]) )
I am using DirectQuery and I am not able to create a new table. Any suggestions please ?
What is your direct query datasource? Is it an SQL datasource?
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 ?
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |