The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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...
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |