Can anyone help me with 6 month rolling average in a calculated column instead of measure

[MandoPavs008]

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

[ThxAlot · Accepted solution]

[MandoPavs008]

Thank you so much. Dax measure with Window worked perfectly for my report. 

[Ashish_Mathur]

Hi,

Why do you need it as a calculated column?  Why not a measure?

[aj1973]

Hi @MandoPavs008 

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.