Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Getting results from past dates

I've got a report that displays scores for different programme areas and a slicer atop that filters the scores by period (4-week time periods.)   I'm using KPIs and want the goal to display the cal...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create columns to get year and Period, then create measure to get average.

     

    Year= MID(Table1[Period],7,4)

     

    Period=INT(MID(Table1[Period],2,2))

     

    Measure1= CALCULATE(AVERAGE(Table1[Score_Value]),FILTER(ALLSELECTED(Table1), Table1[Year]=MAX(Table1[Year])&&Table1[Period]<MAX(Table1[Period])))

     

    Best Regards,

    Amy

     

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

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi  Anonymous ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy