Forum Discussion
AVERAGEX Problems
Anonymous
Try this
Water TRIFR 12MMA = VAR monthrange = 12 VAR result = DIVIDE ( SUMX ( DATESINPERIOD ( 'Calendar'[Date], LASTDATE ( 'Calendar'[Date] ), -1 * monthrange, MONTH ), [Water TRIFR] ), monthrange, BLANK () ) RETURN result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Anonymous
Create another DAX measure and add that in the tooltip.
LastDateValue=LASTDATE ( 'Calendar'[Date] )Then verify its value in both visuals. Maybe it is creating issue.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Anonymous
Try this
Water TRIFR 12MMA =
AVERAGEX (
DATESINPERIOD (
'Calendar'[Date].[Date],
LASTDATE ( 'Calendar'[Date].[Date] ),
-12,
MONTH
),
[Water TRIFR]
)
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Here is my latest blog
https://community.powerbi.com/t5/Community-Blog/Dynamic-Page-Navigation-Based-on-User-Login/ba-p/1097786Anonymous Can you prepare a sample dataset with the same issue and share it here?