Forum Discussion

Mp1977's avatar
Mp1977
Icon for Helper II rankHelper II
3 years ago

Consecutive days with negative values

Hi ! I am trying to calculate the max quantity of consecutive negative values. I managed to create a measure (sqlbi video) that when I use it in a table it works fine, but I need to get the sam...
Need Help
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi

 

it looks like the measure when used in a card is giving you the current consecutive days negative. if you scroll down your table to 21 june 23 (your last record) you'll see that 2 is the current number of consecutive days the value is negative.

 

To get the max number for the card, create a new measure:

 

Measure =
MAXX(VALUES('Grupo Empate'[Date]),[consecutive negative days])
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍