Forum Discussion

AlexEners's avatar
AlexEners
Frequent Visitor
8 years ago
Solved

Sum add all the previous elements to a date

Hi, imagine there is a table with two column: Date and count code. (date show italian month)   This is a table result from a graph. My query have all code in a date. What i need is a table/gr...
Need Help
  • anandav's avatar
    anandav
    8 years ago

    AlexEners,

    You want a running total (cummulative total).

    Check the link below how to do it,

    https://whatthetechisthat.wordpress.com/2017/05/30/power-bi-cumulative-totals/

     

    If your date field in below table is a date heirarchy, then you can choose only month and year. You need to have a calendar table and establish relatship with your data table.

     

     Running Toal Measure =

          CALCULATE(

              Sum(Table[Value],

              FILTER(All(Dim_Date[Date]), Dim_Date[Date] <= MAX(Dim_Date[Date]

              )

            )

quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

Hi AlexEners

 

Here what I would do : 

1 - Create a new calculated colum to get your month name. 

 

MonthName = YourTable[DataInzoFornituraMese].[Mese]

 

(Not sure about the spelling as i'm trying to write this formula in italian)

 

2 - Use this month name + Sum of Conteggio di CodidePOD in a visual.

 

- Quentin