Forum Discussion

sprao's avatar
sprao
Helper I
5 years ago
Solved

Cumulative Table with selected date from Line chart

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 se...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
sprao
Helper I
5 years ago

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