Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I'm facing some strange issue.
Looking at table in data. three entries from 7 Jul 2022 is missing in report. I had include all data from Jul below.
And this is the total amout I have in Report
Only applied with below filters which should not impact on calculation.
However, if I manual change the date to 17 Jul 2022 as below shown. All numbers are able to shown in report.
I do not want to change the date. And can someone please help me to resolve this issue?
Solved! Go to Solution.
Actually my date table was not covering the data's date. I changed dynamic date range to cover the data's date.
Hence, this issue resolved.
Thank you. Managed to resolve it.
please can you share how you solved it and then set it to the solution so this thread can be closed thank you.
Proud to be a Super User!
are you able to share your file at all? its quite difficult to figure it out with the screenshots as there is obviously something going on but it wont be obvious in what you have provided.
Proud to be a Super User!
Actually my date table was not covering the data's date. I changed dynamic date range to cover the data's date.
Hence, this issue resolved.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |