Cumulative adding of a static number

[ZaneCoetzee]

Hi All

Trust you are all well

I'm hoping someone can guide me to a solution.

I have added a static number, 71. I need to add  this number over 22 working days. So day 1 =71, Day 2 = 141 and so forth.......
Sample Data in table below:

Working Day	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
Business Plan opportunities (Cumulative)	71	141	212	282	353	423	494	564	635	705	776	847	917	988	1,058

I have tried the following DAX expression:

Tot. Business Plan Opportunities =

VAR workday = MIN(Workingdays[Working_Day_Number])

RETURN

Calculate(

[Business Plan Opportunites per workday],All(Workingdays[Working_Day_Number]) ,

Workingdays[Working_Day_Number] <= workday

)

But I am still recieving the the value of 71 on every workday.

I am in need of the community's wisdom 🙂

Many Thanks 

Zane

[Greg_Deckler · Accepted solution]

@ZaneCoetzee Try:

Tot. Business Plan Opportunities =
VAR workday = MIN(Workingdays[Working_Day_Number])
VAR __Result = workday * 71
RETURN
__Result

[ZaneCoetzee]

Hi Greg

Solution worked. thank you for the assistance. Greatly appreciated

Kind Regards 

Zane