Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
5 years ago
Solved

Line graph question

Goodmorning guys, i need your help with a simple question   I want a line graph that displays the cumulative value of a certain value We register on a daily basis the number of new contracts that ...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, RonaldvdH 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

    You may create a measure as below.

    Result = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        [YearWeek]<=MAX('Table'[YearWeek])
    )
)

     

    Result:

     

     

    Best Regards

    Allan

     

    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

RonaldvdH , if you are using a date table and week is part of that then it will give cumulative with dates

example

Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Date),Date[Date] <=max(Date[Date])))

or

 

Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))

 

else create a week rank in table and use that

Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYMM format

Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Date),Date[Week Rank] <=max(Date[Week Rank])))

 

  • RonaldvdH's avatar
    RonaldvdH
    Post Patron
    5 years ago

    I dont have a date table so is there an option to work with the data i do have ?

    I have a table with dates in them and i use a formula to convert (to a string) the dates into a week number format YYYY-MM