Forum Discussion
extracting first and last entries between dates
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?
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.
1 Reply
- Icey
Community Support
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.