Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Category | Date | Count |
AA | 1-Apr-22 | 30 |
AA | 1-May-22 | 31 |
AA | 1-Jun-22 | 30 |
AA | 1-Jul-22 | 31 |
AA | 1-Aug-22 | 31 |
AA | 1-Sep-22 | 30 |
AA | 1-Oct-22 | 31 |
AA | 1-Nov-22 | 30 |
AA | 1-Dec-22 | 31 |
AA | 1-Jan-23 | 31 |
AA | 1-Feb-23 | 28 |
AA | 1-Mar-23 | 31 |
AA | 1-Apr-23 | 30 |
AA | 1-May-23 | 31 |
AA | 1-Jun-23 | 30 |
AA | 1-Jul-23 | 31 |
AA | 1-Aug-23 | 31 |
AA | 1-Sep-23 | 30 |
AA | 1-Oct-23 | 31 |
AA | 1-Nov-23 | 30 |
AA | 1-Dec-23 | 13 |
AB | 1-Apr-22 | 3 |
AB | 1-May-22 | 6 |
AB | 1-Jun-22 | 5 |
AB | 1-Jul-22 | 10 |
AB | 1-Aug-22 | 11 |
AB | 1-Sep-22 | 8 |
AB | 1-Oct-22 | 3 |
AB | 1-Nov-22 | 5 |
AB | 1-Dec-22 | 13 |
AB | 1-Jan-23 | 5 |
AB | 1-Feb-23 | 6 |
AB | 1-Mar-23 | 2 |
AB | 1-Apr-23 | 11 |
AB | 1-May-23 | 4 |
AB | 1-Jun-23 | 10 |
AB | 1-Jul-23 | 14 |
AB | 1-Aug-23 | 4 |
AB | 1-Sep-23 | 7 |
AB | 1-Oct-23 | 6 |
AB | 1-Nov-23 | 1 |
AC | 1-Apr-22 | 19 |
AC | 1-May-22 | 21 |
AC | 1-Jun-22 | 26 |
AC | 1-Jul-22 | 19 |
AC | 1-Aug-22 | 27 |
AC | 1-Sep-22 | 26 |
AC | 1-Oct-22 | 22 |
AC | 1-Nov-22 | 24 |
AC | 1-Dec-22 | 25 |
AC | 1-Jan-23 | 17 |
AC | 1-Feb-23 | 15 |
AC | 1-Mar-23 | 27 |
AC | 1-Apr-23 | 26 |
AC | 1-May-23 | 30 |
AC | 1-Jun-23 | 28 |
AC | 1-Jul-23 | 24 |
AC | 1-Aug-23 | 23 |
AC | 1-Sep-23 | 4 |
AC | 1-Oct-23 | 9 |
AC | 1-Nov-23 | 8 |
AC | 1-Dec-23 | 2 |
AM | 1-Apr-22 | 11 |
AM | 1-May-22 | 19 |
AM | 1-Jun-22 | 18 |
AM | 1-Jul-22 | 12 |
AM | 1-Aug-22 | 17 |
AM | 1-Sep-22 | 11 |
AM | 1-Oct-22 | 16 |
AM | 1-Nov-22 | 12 |
AM | 1-Dec-22 | 19 |
AM | 1-Jan-23 | 9 |
AM | 1-Feb-23 | 19 |
AM | 1-Mar-23 | 17 |
AM | 1-Apr-23 | 19 |
AM | 1-May-23 | 17 |
AM | 1-Jun-23 | 19 |
AM | 1-Jul-23 | 22 |
AM | 1-Aug-23 | 17 |
AM | 1-Sep-23 | 3 |
AM | 1-Oct-23 | 1 |
AM | 1-Nov-23 | 4 |
I tried to add 6 month rolling average as a calculated column to the above existing table but the same count column is being repeated as 6 month average. Can anyone help to get the calculated rolling average column in a table
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Thank you so much. Dax measure with Window worked perfectly for my report.
Hi,
Why do you need it as a calculated column? Why not a measure?
Rolling average is a Time Intelligence function using DAX, for that you need to create Date Table and you can use Quick measure to add the measure to your visual.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |