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.

P_D_G's avatar
P_D_G
Resolver III
5 years ago

Hi,

 

have you tried adding a Quick Measure - Running total? Usually it works fine.

 

Or you can create a measure on your own as well:

calculate( SUM( YourColumn ), Filter (all ( YourTable[DateColumn] ), YourTable[DateColumn] <= MAX(YourTable[DateColumn]) )

 

Or you can do the same in Power Query:

https://www.youtube.com/watch?v=uX3_dnb5on0

 

  • RonaldvdH's avatar
    RonaldvdH
    Post Patron
    5 years ago

    Your formula doesn't seem to work because i used a formula to convert my date to a week using this formula in the advanced editor:

    if [actief aangemeld] = null then ""
    else
    Text.From(Date.Year([actief aangemeld])) & "-" & Text.PadStart(Text.From(Date.WeekOfYear([actief aangemeld])), 2, "0")

     

    The result is a string and therefor it doesn't work i think