Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SLima
Helper I
Helper I

Previous line

Get previous value.

 

previous.JPG

 

 

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @SLima 

 

Try this code to add a new column:

Calculada = 
VAR _A =
    CALCULATE (
        MAX ( 'Table'[Coluna 1] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] < EARLIER ( 'Table'[Coluna 1] ) )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Coluna 2] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] = _A )
    )

 

output:

VahidDM_0-1636500180562.png

 

 

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

Appreciate your Kudos!!

 

View solution in original post

2 REPLIES 2
VahidDM
Super User
Super User

Hi @SLima 

 

Try this code to add a new column:

Calculada = 
VAR _A =
    CALCULATE (
        MAX ( 'Table'[Coluna 1] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] < EARLIER ( 'Table'[Coluna 1] ) )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Coluna 2] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Coluna 1] = _A )
    )

 

output:

VahidDM_0-1636500180562.png

 

 

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

Appreciate your Kudos!!

 

smpa01
Super User
Super User

@SLima  you would need a row identifier in the dataset

Column =
VAR _0 =
    CALCULATE ( MAX ( 'Table'[RowIdentifier] ) )
VAR _1 =
    CALCULATE (
        MAX ( 'Table'[Column2] ),
        FILTER ( ALL ( 'Table' ), 'Table'[RowIdentifier] = _0 - 1 )
    )
RETURN
    _1

 

smpa01_0-1636482811104.png

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.