Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |