Need halp in solving copying row value in table

Check out this video on how to use visual calculations:

https://www.youtube.com/watch?v=eDRgzEVwVEc

Select a matrix visual and add a new column calculation. The previous function looks at the row thats above the current row.

Hi mohsin-raza ,

Thanks for clarifying and sharing the error message.

The behavior you’re seeing is expected as PREVIOUS() only works in Visual Calculations, so it can be used in visuals like Matrix or Table, but not as a calculated column in the data model.

If you just want to display the filled values in visuals, Visual Calculation is the right approach. But if you need this as a calculated column in your table, PREVIOUS() won’t work. Instead, you can use Power Query’s Fill Down transformation on the Project leader and Task columns when [Project] = 900 and [Articalname] = "fever", which will persist the values in your data model.

Hope this helps, Please feel free to reachout for any further question.

Thank you.

Got it. It's perhaps a bit hidden, but this is an easy fix that I called out in the comments of my DAX:

Here is the code again with this quick tweak for easy reference:

Project Leader Filled = 
VAR _thisRank = RANK( ORDERBY( Data[Date], ASC ), PARTITIONBY( Data[Project] ) )
VAR _thisDate = Data[Date]
VAR _validRows = FILTER( 
    ALL( Data[Date], Data[Project], Data[Project Leader], Data[Task] ), 
    Data[Project Leader] <> BLANK() && Data[Task] <> BLANK() // assuming you want non-blank but remove otherwise
    && Data[ArticleName] <> "900" && Data[Date] < _thisDate 
)
VAR _validPrevious = INDEX( 
    1, _validRows, ORDERBY( 
        Data[Date], DESC,
        Data[Project], DESC // changed to DESC so we get "AAA"
    ) 
)
RETURN
IF(
    Data[Project] = "900" && Data[ArticleName] = "fever" && _thisRank = 1,
    CALCULATE( VALUES( Data[Project Leader] ), _validPrevious, REMOVEFILTERS( Data ) ),
    Data[Project Leader]
)

Task Filled = 
VAR _thisRank = RANK( ORDERBY( Data[Date], ASC ), PARTITIONBY( Data[Project] ) )
VAR _thisDate = Data[Date]
VAR _validRows = FILTER( 
    ALL( Data[Date], Data[Project], Data[Project Leader], Data[Task] ), 
    Data[Project Leader] <> BLANK() && Data[Task] <> BLANK() // assuming you want non-blank but remove otherwise
    && Data[ArticleName] <> "900" && Data[Date] < _thisDate 
)
VAR _validPrevious = INDEX( 
    1, _validRows, ORDERBY( 
        Data[Date], DESC,
        Data[Project], DESC // changed to DESC so we get "BBB"
    ) 
)
RETURN
IF(
    Data[Project] = "900" && Data[ArticleName] = "fever" && _thisRank = 1,
    CALCULATE( VALUES( Data[Task] ), _validPrevious, REMOVEFILTERS( Data ) ),
    Data[Task]
)

Note, when multiple projects fall on the most recent previous project date, we'll select the one that is last when sorting project name alphanumerically.

Imporant note. This is not just getting the project lowest down in the visual or data. DAX does not have a sense of "original order" - when order of rows matters, we must define it ourselves via some column or expression depending on function. E.g., if we actually want latest project ID  (rather than last alphanumeric project name), we would have to switch out Data[Project] for Data[Project].