Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Previous Quarter Calculation

How can I write Dax that will give me the average of Quarter 1's numbers below?:   It's tricky because when using the AVERAGE function, I'm not allowed to select my [Retention] measure for ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Try AVERAGEX, something like:

     

    Measure = AVERAGEX(FILTER('Table',[Year]=2018 && [Quarter]="Qtr 1"),[Retention])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Try AVERAGEX, something like:

 

Measure = AVERAGEX(FILTER('Table',[Year]=2018 && [Quarter]="Qtr 1"),[Retention])
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg_Deckler Would this work the same if the dates I'm referencing are from a different table? The date columns come from a Date table while the retention comes from my fact table. Sorry, forgot to clarify that part.