Forum Discussion

DanJaques's avatar
DanJaques
Regular Visitor
8 years ago
Solved

Sum by Month

Hello Everybody! I have this table and I want create one measure who SUM the column VALUE by month.  DATA VALUE 10/01/2016 10 10/02/2016 10 11/01/2016 20 11/02/2016 20 12/03/...
Need Help
Tutorial Requests
  • DanJaques's avatar
    DanJaques
    8 years ago

    I solve it

    Measure = CALCULATE(SUM(Sheet1[Value]);FILTER(ALL(Sheet1);Sheet1[Value]<=MAX(Sheet1[Value])))

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi DanJaques

 

1. Create a calculated column Date_Month = FORMAT(Table1[DATA],"YYYY/MM")

2. Create a Measure Sum_Value = SUM(Table1[VALUE])

 

Hope this helps.

 

 

Thanks
Raj

  • DanJaques's avatar
    DanJaques
    Regular Visitor
    8 years ago

    Hi Anonymous

    First, thaks for helping.

    This way you told me works, but the dashboard already have a filter by date who is connected with another graphics.

    If the data is full and I use your Date_Month, it works perfectly.

     

     

     

     

     

     

     

     

     

    But if I change the date I lost my value who actually should be  310(full value January)+580(full value of january) = 890

      

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Do you still need date slicer, as you have date_Month slicer, which serves the same purpose?

       

      Thanks

      Raj

      • DanJaques's avatar
        DanJaques
        Regular Visitor
        8 years ago

        Anonymous 

        Sadly, yes, because I already have a dinamic dashboard who the managers use the slicer to see weeks and fortnights about another graphics.

         Also, I have another dashboards who sincronize with this slicer.

         

        As possible, this measure that I would like to make is for create a goal to another graphic mine