extracting first and last entries between dates

[sp_nokia_nz]

I want to achieve the following and wondering if it is even possible with power BI

There is a database that maintains all the historic changes to various servers in the network.

I want to be able to generate a report that gives me an the from and to value for a server change between a given period. Eg Refer the table below:

Server_name	date of change	original value	new value
server_1	04-10-2019	change_1	change_2
server_1	04-12-2019	change_2	change_3
server_1	04-1-2020	change_3	change_4
server_1	04-2-2020	change_4	change_5

If I want to see the change on server_1 in the last 4 months (or a between two dates using a filter option),  the result must be:

Server_name	original value	new value
server_1	change_1	change_5

Is this possible with any of the formula in power BI?

[Icey · Accepted solution]

Hi @sp_nokia_nz ,

Please check if this is what you want:

Create measures like so:

Original Value Measure = 
CALCULATE (
    MIN ( 'Table'[original value] ),
    FILTER ( 'Table', 'Table'[date of change] = MIN ( 'Table'[date of change] ) )
)

New Value Measure = 
CALCULATE (
    MAX ( 'Table'[new value] ),
    FILTER ( 'Table', 'Table'[date of change] = MAX ( 'Table'[date of change] ) )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.