Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Month-by-Month calculated column

Hi Guys, I created a calculated column which calculates the SoM, its formulae is: SoM = Sheet1[Mio Sales]/ SUM(Sheet1[Mio Sales])   The thing is, I need the SoM to be calculated on a month-by-mont...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

 

Since you didn't provide the sample data,hope this is helpful.

 

% = 'Table'[sales]/CALCULATE(SUM('Table'[sales]),FILTER('Table','Table'[month]=EARLIER('Table'[month])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ryan_mayu , 

     

    thank you so much it worked 😄