Calculate measures for the times of the minimum and max dates of the range slicer

[marijane21]

Hi everyone!
I have a date range slicer
For each date I have a column on my table for all the times of the date and the respective values for the fields.
I need to show all the times for the minimum and maximum dates of the date range slicer and calculate the measures respectively.
I achieved this with two matrix with TOPN filter pane. But this is not What I want. I want a single column with all the times from the minimum and max dates form the range and the values of the measures. I have to this in the mode  of direct query.
Can you help me please? 🙂 Many thanks in advance!

[marijane21]

Thank you for your feedback! you are right. I just wrote another message because this was incomplete and confusing and I was not getting any help. Here my post with example and sample.
https://community.fabric.microsoft.com/t5/Desktop/Calculate-sum-and-deltas-for-the-min-and-max-dates...

[Anonymous]

Hi @marijane21 

Sorry I don't quite understand what the output should be like. Can you please show the expected output with some sample data? Does all data come from the same data table? And what is the measure calculating? 

Best Regards,
Jing