Forum Discussion

Robapottamus's avatar
Robapottamus
Regular Visitor
9 years ago
Solved

Cumulative Line Chart to compare performance of multiple products over time

Hi - I am trying to compare the performance of multiple products over time (years), using a line chart. At the moment I am using a Measure called Cumulative Value to sum the cost and revenue for eac...
Need Help
  • KamK's avatar
    KamK
    9 years ago

    Hi Robapottamus

     

    For time intelligence functions Ive fount it best to have a separate date table (with unique dates) and create a relationship with your exsisting data table.

     

    Assuming your new date table is called  DateKey and the column called Date , try the following

     

    Cumulative Value = CALCULATE(SUM('Data Table'[Value] ),FILTER(ALL(DateKey),DateKey[Date]<=MAX('Data table'[Date])))

     

    Hope this helps

     

     

     

     

KamK's avatar
KamK
Frequent Visitor
9 years ago

Hi Robapottamus

 

For time intelligence functions Ive fount it best to have a separate date table (with unique dates) and create a relationship with your exsisting data table.

 

Assuming your new date table is called  DateKey and the column called Date , try the following

 

Cumulative Value = CALCULATE(SUM('Data Table'[Value] ),FILTER(ALL(DateKey),DateKey[Date]<=MAX('Data table'[Date])))

 

Hope this helps

 

 

 

 

Robapottamus's avatar
Robapottamus
Regular Visitor
9 years ago

Thanks KamK, that seems to do the trick. I haven't considered the idea of using a separate Dates table previously so will need to get my head around how I can use these going forward. Cheers!