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.
I have a measure setup to sum with a filter whch gets me a sum of the rejects for last week.
Hi, @StephenGW ;
It's really hard to understand the problem corresponding to your data , can you provide more samples?
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok, I will try to explain better. I have changed paths and would like to show a KPI with current MTD vs last MTD. I have a column of dates and a column of quantities. I want to sum the quantities MTD and last MTD and compare them in a KPI. I used this to get the current MTD
Also odd, when I put the Date column in the Trend Axis as the Date it only shows 13 of the 14 with the colored graph background but if I change it to the hierarchy (year) it shows all 14 with no colored graph background. Hierarchy (day) shows the colro and 13 again. Seems to be a problem with the date but the dates are 2/7/2022 and 2/8/2022 Any ideas on either of these things would be helpful.
Thanks
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |