Forum Discussion
Helper IOccupany, 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 below zero, if anyone would be able to help it would be greatly appreciated 🙂
13 Replies
- amitchandak
Super User
molzmad ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try
a new column =
if([Occupancy] <0 , 0, [Occupancy])
molzmadHi, i have attached a sample here, i tried do the new column and it didnt work :(, thanks so much for taking a look i really appreciate it 🙂
https://drive.google.com/file/d/11ubbPcRiZDj--3osMqBtXziRB4mZ5r3m/view?usp=sharing- molzmad
I basically need it to do a running total, but if the total goes below zero then to make it zero, as i dont want the occupancy levels going into minus 🙂
