Forum Discussion
Finding Start/End values for record within data log
Hi I suppose since your data source is sql database you could use SQL command and some window functions in your particular case to get the described output this is done before the data is loaded into power bi
Secondly in power query you can use groupby and some operations on that like for this such as first or las after sorting the Task_Id colmn
Third you can achieve this by writing DAX query also
Hope this helps
Hi I suppose since your data source is sql database you could use SQL command and some window functions in your particular case to get the described output this is done before the data is loaded into power bi
Secondly in power query you can use groupby and some operations on that like for this such as first or las after sorting the Task_Id colmn
Third you can achieve this by writing DAX query also
Hope this helps
Hello Akash_Varuna,
Thank you for the clue, I used Grouping in power query, then sorted by date, then added index column to the table and filtered the very first record. Using this method I got the initial value.
To get the last value I assumed that last value is the same as actual value in task estimates and joined two tables to get the final value.
Thank you.
No Problem Happy to help !!