Forum Discussion

BartoszKx's avatar
BartoszKx
Regular Visitor
2 years ago

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: ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BartoszKx , rajendraongole1, thank you for your prompt reply!


Please create a simple measure to check if you could return month values in a table:

Best regards,

Joyce

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.