Finding Start/End values for record within data log

[high20zero]

Hello Community,

I'm a newbie here and also learning Power BI. I'm currently creating a dashboard for projects, and one of the specific values is a project estimate change. I am stuck here, and the question is how to find the initial start value and final changed value for the field TASK_ID within data log. 

Data source is SQL database.

One case is when one record has several changes and values are increasing.

Another is when one record has a variety of changes

I would appreciate any advice help on this topic

[Akash_Varuna · Accepted solution]

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

[high20zero]

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.

[Akash_Varuna]

No Problem Happy to help !!