Average of last 6 months data in cards

[dinesharivalaga]

Hi All ,

I am getting error message below when i am using Averagex DAX for my scenario.

I want to get the average values in card visual from the last 6 months data in line chart.

Below the error message and the data visuals (the one with title of Project Code Creations)

Please help to fix this issue for me 😞 

Good Friday .. TIA 🙂

TR

Dinesh

[Dangar332 · Accepted solution]

hi, @dinesharivalaga 

in your datesinperiod update like below

=
datesinperiod(
    'PA-GLOBAL LANDING PAGE'[MONTH],
     MAX('PA-GLOBAL LANDING PAGE'[MONTH]),
     -6,
     MONTH
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[isha_7 · Accepted solution]

Hello @dinesharivalaga ,

If you want to get the average values in card visual, use AVERAGE instead of AVERAGEX.

Here is the code for that.

Replace 'financial[Sales Price]' with '[Total project code creation]' 

       and 'financial[Date]' with '[Your date column].

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Dangar332 · Accepted solution]

hi, @dinesharivalaga 

in your datesinperiod update like below

=
datesinperiod(
    'PA-GLOBAL LANDING PAGE'[MONTH],
     MAX('PA-GLOBAL LANDING PAGE'[MONTH]),
     -6,
     MONTH
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly