Forum Discussion

Tevon713's avatar
Tevon713
Icon for Helper V rankHelper V
4 years ago
Solved

Sum per month per value

Hi all,   This subject may be solve somewhere. I can't seem to get my head around to it. Create measure to sum per month/year of the value. Also there will be a date filter slicer for user selectio...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Tevon713 l

     

    I pasted your data into a table in PBI:

     

     

    Then, I created a simple measure:

    SumMachineMeasure =  SUM ( Table[No. of  Machine] )

     

    Lastly, I dragged the measure into a table visual with the Year and Month. Note, the year column might have an implicite sum. Choose "don't summarize" instead:

     

     

    Power BI does the grouping for you by applying filters in the visual.

     

    Let me know if this helps or if you have any questions!

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Tevon713 

create a table visual. Inset the year and the month columns. Make sure to select "don't summarize". 
create a measue

SUM ( TableName[No. of Machine] )

inset the measure into the table.