Forum Discussion

Marcin's avatar
Marcin
Icon for Helper V rankHelper V
7 years ago
Solved

Average per month in quarter

HI,   I am looking for DAX solution for this calculation:   Quarter Month Bonus 2018Q1 Jan-18 36000 2018Q1 Feb-18   2018Q1 Mar-18   2018Q2 Apr-18 27000 2018Q2 May-18 ...
Need Help
  • Omega's avatar
    Omega
    7 years ago

    Assuming you are using table 1, try creating the below measure 

     

     

    Average per Quarer = CALCULATE(SUM(Table1[Bonus])/3,ALLEXCEPT(table1,Table1[Quarter]))

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
7 years ago

The formula in my previous post was used as a measure. If you want to use a column, try: 

 

Average  = IF(ISBLANK(Table1[Bonus]),BLANK(),Table1[Bonus]/3)
Marcin's avatar
Marcin
Icon for Helper V rankHelper V
7 years ago

Hi Omega,

 

thanks, I understad now.

 

Any idea how to extend those average values into months wihtout Bonus ?

 

  • Marcin's avatar
    Marcin
    Icon for Helper V rankHelper V
    7 years ago

    We can also assume that there is time table with Months and Quarters as dimension.