Generate a column that contains only last 3 values from another column

[Anonymous]

Hello all,

I am fairly new to PowerBI and more specifically - DAX.I would like to know the following : is there a way to generate a column using DAX formula which  takes the values of  only the last 3 rows from another column? I will attach a screenshot of the expected result below.

Thanks in advance for your help!

[Whitewater100]

Hi:

Maybe you can add an index column on this table via Power Query. TRANSFORM>ADD NEW COLUMN > INDEX COLUMN > Index from 1. The last three in your example are index 6-8. I'll call your table "Data".

Then you can do an IF statement.

Result = IF(Data[Index] IN { 6, 7, 8}, Data[Value], BLANK()).

You can also use TOPN to make a table.

Bottom 3 Index Values = TOPN(3, VALUES(Data[Value]), 

                                        CALCULATE(SUM(Data[Index])), 
                                       DESC
                                                )

I hope this helps solve your question..

[Anonymous]

The index will be always changing.I think I didnt provide the right example,here is a better one  :