Count if previous value is bigger than a number

[andry456]

Hi everyone,

I'm having troubles trying to make a new measure in PowerBi. I have a column regarding of instantaneous energy production value and I'd like to make a counter of any daily stop.

This is the idea: if the value of N row is less than X AND the value of the previous row (N-1) is bigger than X, the measure must return "1"; instead, it will return "0".

I tried using COUNT formula without success.

Can you plase give me an hand?

Thank you!

[v-yuta-msft · Accepted solution]

@andry456 ,

Suppose the X is 20, you could create a calculate column using dax below:

Flag = 
VAR X = 20
VAR Current_Value = 'Table'[Value]
VAR Previous_Index = 'Table'[Index] - 1
VAR Previous_Value = CALCULATE(MAX('Table'[Value]), FILTER('Table', 'Table'[Index] = Previous_Index))
RETURN
IF(X > Current_Value && X < Previous_Value, 1, 0)

 

Community Support Team _ Jimmy Tao

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

[Anonymous]

Hi,

For the sake of this Demo, I would assume your X=50 

Calculated Column:= 
VAR PreviousRow =
    TOPN (1,FILTER (
            Table1,
            Table1[Column1] < EARLIER ( Table1[Column1] )
                && Table1[Column2] = EARLIER ( Table1[Column2] )), [Column1], DESC)
RETURN IF( AND(Table[ColumnA]>50,Table[ColumnB]>50),1,0)

Consider two columns from your table as [Column1] && [Column2].