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 am developing a dashboard where I return the number of entries made month to month in a given year.
I would like this chart to also have a line with the average entries each month, but I don't know how to do this average calculation.
Not every day of each month is in the database, only the days that the registrations existed and I need to divide the number of registrations of each month by the number of days of the current month.
I even tried to create a null query where I put it every day, from the first database to the current one, but it still didn't return what I need, because the measurement didn't fit the chart and was in the total amount of days.
I don't know what to test anymore.
Solved! Go to Solution.
Hi mirelaathayde,
You could refer to my sample for details. If this is not what you want , please correct me and inform me more detailed information (such as your sample data and your expected output). Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mirelaathayde,
You could refer to my sample for details. If this is not what you want , please correct me and inform me more detailed information (such as your sample data and your expected output). Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the help, I managed to solve the problem with your example!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |