Forum Discussion

molzmad's avatar
molzmad
Icon for Helper I rankHelper I
5 years ago

Occupany, Culmulative total help

Hi, i basically have a column labeled occupancy 2, which is a culumaltive total of people entering or exiting a building, im wanting to understand how to modify my DAX so that the occupancy 2 cant go...
Need Help
molzmad's avatar
molzmad
Icon for Helper I rankHelper I
5 years ago

Hi,
Yes thats right, but how come it doesnt start counting from the beggining i.e. top row? Is there anyway to implement this? For example its counting some of the ins as 0

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi molzmad ,

 

Thanks for your reply. I think it does count from the beginning. You can sort the "timestamp" column ascending. 

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • molzmad's avatar
    molzmad
    Icon for Helper I rankHelper I
    5 years ago

    Hi, 
    yeah it does seem to work but i mean for example you have put above, in the second row, the value for Ins_Outs = 1, so "column" should = 1  if that makes sense ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi molzmad ,

       

      So you want to create a new column, where the negative value is zero and the positive value remains the same, right?

       

      Best Regards,

      Yuna

      • molzmad's avatar
        molzmad
        Icon for Helper I rankHelper I
        5 years ago

        Yeah basically, i just want the accumulated column to count but not go below zero :),

        Thanks :),
        Molly