Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
marijane21
Frequent Visitor

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

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_0-1706531174856.png

 

2 REPLIES 2
marijane21
Frequent Visitor

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...

v-jingzhan-msft
Community Support
Community Support

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.