Forum Discussion

pal95's avatar
pal95
Icon for Helper III rankHelper III
4 years ago
Solved

Cumulative Line Chart for Mileage Register

Hi, I have a huge 'timesheet' like dataset where every employee registers the car they used and how many miles they made:     It generates a nice line chart where I can see mileage change...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    pal95 , Using a date table in measure and visual axis

     

    Cumm = CALCULATE(SUM(Table[Miles]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    or

     

    Cumm = CALCULATE(SUM(Table[Miles]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

keshavagrawal27's avatar
keshavagrawal27
Icon for Resolver I rankResolver I
4 years ago

Hello pal95,

It can be acheived by using Bar Chart.

 

If this helps you then please mark it as a solution and hit the thumbs up. Thanks.

  • pal95's avatar
    pal95
    Icon for Helper III rankHelper III
    4 years ago

    I need a line chart to then compare it with other data