Forum Discussion
Measure doesn't work for records before specific date
Hi, When I was trying to calculate average number of players in selected date range, i found out that measures doesn't work correctly for dates before 09-2014. I created this temporary measure: ...
Hi Anonymous,
Thank you for your reply. This measure doesn't work in report. I can't retrive month from date column:
Here's sample data and report:
https://drive.google.com/file/d/1NdD5gDj1GWpa-6E-Zyk0yuBtH2wkP01K/view?usp=sharing
Hi BartoszKx，
Thank you for your additional information, use All function to ignore any filters that might have been applied.
tmp = CALCULATE(AVERAGEX('GameStatistics','GameStatistics'[Avg players]), ALL(GameStatistics),YEAR('GameStatistics'[Date]) = 2014, MONTH('GameStatistics'[Date]) =8)
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.