Show Previous Values Per Day

[SirBI]

I have the following table loaded into PBI. I can get the previous count per day using `PreviousDay` but when I want to add in another column I have trouble understanding how. 

Date	Count	RequestBucket
11/2/2022	10	Red
11/2/2022	20,000	Green
11/1/2022	3	Red
11/1/2022	25,000	Green

 How can I capture the previous count per date and RequestBucket?

New table:

Date	PreviousCount	Count	RequestBucket
11/2/2022	3	10	Red
11/2/2022	25,000	20,000	Green
11/1/2022	Null	3	Red
11/1/2022	Null	25,000	Green

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Previouscount CC =
MAXX (
    FILTER (
        Data,
        Data[RequestBucket] = EARLIER ( Data[RequestBucket] )
            && Data[Date]
                = EARLIER ( Data[Date] ) - 1
    ),
    Data[Count]
)