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.
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
Solved! Go to 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
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
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
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
User | Count |
---|---|
69 | |
43 | |
21 | |
20 | |
14 |
User | Count |
---|---|
124 | |
41 | |
39 | |
28 | |
24 |