item no wise Last 3 Transaction filter with posting date

Hi Anonymous ,

First you need to create a date table that is not associated as a slicer.
Then you need to enter "edit queries" to create an index column as the sorting condition, and you need to sort the date before creating the index column.
Then create the measure and apply the filter

Measure =
    IF (
        MAX ( test[Posting date] ) <= SELECTEDVALUE ( 'Table'[Posting date] ),
        RANKX (
            FILTER (
                ALLEXCEPT ( test, test[Item No] ),
                test[Posting date] <= SELECTEDVALUE ( 'Table'[Posting date] )
            ),
           [measure2],
            ,
            DESC
        )
    )

You can also refer to the pbix

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