Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |