Calculate column data for a date based upon a slicer

[AutyDA]

I am new to PowerBI and slowly learning how to advance.

I have different financial data for various companies and periods. Based upon a series of slicers (company, dates, quarterly/annual data) this data is filtered. From this filtered data I want to identify the data at the chosen start and end dates. I've added some measures which determine the start and end dates selected by a slicer but don't know how to use this to find the data (revenue for example) on these dates.

For example, in the visual shown below the yellow box is reporting on the results of the slicers and I am trying to obtain the revenue on the starting data (2.5m based upon the slicers) and end date (3.5m based upon the slicers) and a comment on this.

Here is a link to the sample data I am using - Sampledata.pbix 

Any help appreciated.

[AutyDA]

Thank you, that worked perfectly!

[zenisekd · Accepted solution]

Hi, create these two measures (not columns):

FirstDateRevenue =
CALCULATE (
SUM ( 'Table'[Revenue] ),
'Table'[Date] = MIN ( 'Table'[Date] )
)

LastDateRevenue =
CALCULATE (
SUM ( 'Table'[Revenue] ),
'Table'[Date] = MAX( 'Table'[Date] )
)