How to make a row in a certian column start in the negative and add a constant value at each new row

[Anonymous]

Hi All,

Very new to PowerBI and I have been stuck on this problem for a while now. I'm trying to make it so Day 0 starts at -5,000 and with each additional day, $1500 is added to the -5000. So day 1 would be -3500, day 2 -2000, day 3 -500, day 4 1000 and so on. Both columns circled in Red are measures created from a slicer.

I am eventually wanting this to be graphed out in a line graph.

Am I going about this right? Is there an easier or more effective method of achieving what I am trying to achieve? Should I be creating a new table for this instead? Or is there really no way of achieving this?

It is also important to note that the slicer measures E-Bin cost and Profit (Day) are also influenced by other slicers - if that adds any more additional information.

Thank you for reading 🙂

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this measure:

Measure = 
Var _R = max(table[day])
return
[E-Bin Cost]+(_R*1500)



or 


Measure = 
Var _R = max(table[day])
return
[E-Bin Cost]+(_R*[Profit (day)])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

Hi @VahidDM 

It does not appear to be accepting this DAX code as a new measure. Any thoughts? Or am I inputting this in the wrong place? 

[VahidDM]

@Anonymous 

The RETURN missed from my code.

Make sure you copy and past code.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

Ah yes! 

@VahidDM it has indeed worked thank you very much, deeply appreciative!