Cumulative Table with selected date from Line chart

[sprao]

Hi Team,

How to show cumulative table based on selected date from line chart.

Ex: Line chart with cumulative values with X-axis Finish date

Right hand side i have detail table, if i select any position in line chart based on selected date right hand side in detail table also need to show cumulative details.

Like if selected date in line chart 30/09/2020, want to show in detail table <= 30/09/2020 all the information its like cumulative information based on selected date.

Can you help me this scnario..

Thank you

[v-stephen-msft · Accepted solution]

Hi @sprao ,

It looks like you may create a separate table.

In my test, I duplicated a sample table, and then there is no relationship between the two tables, this is to display all the dates before the selected date.

The measure is this.

Values =
CALCULATE (
    SUM ( 'Table (2)'[Value] ),
    FILTER ( 'Table (2)', [Date] <= SELECTEDVALUE ( 'Table'[Date] ) )
)

You can check more details from here.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sprao]

Hi Stephen Tao,

Thank you so much for your help, it worked your solutions.

[Fowmy]

@sprao 

You try this  measure:

Cummulative Task = 

CALCULATE(
    SUM(Table[Task]),
    FILTER(Allselected('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[sprao]

Hi Fowmy,

Thank you for reply,

i do not sum task information, want to show all taskes list before that date

Ex: selected toolip on 30/09/2020 in line chart

Present it showing only 2 instead of 17 taskes before that date. because when i select that date in line chart only two tasks on particular date.

Want to show in table all 17 tasks before that date

[amitchandak]

@sprao , with a date table try like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))

or like

Cumm Sales =
var _max = maxx(allselcted(date),date[date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date]) && date[date] <=_max))

[sprao]

Hi Amit,

actuvally dont have any column related to measure value or sum value, i want show detail data like before that date Tasknames and other realted infromation