Forum Discussion

SirBI's avatar
SirBI
Frequent Visitor
3 years ago
Solved

Show Previous Values Per Day

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. 

                     

DateCountRequestBucket
11/2/2022     10              Red
11/2/202220,000Green
11/1/20223Red
11/1/202225,000Green

 

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

 

New table:

Date               PreviousCount      Count   RequestBucket
11/2/2022310Red
11/2/202225,00020,000Green
11/1/2022Null3Red
11/1/2022Null25,000Green

 

EARLIER
PREVIOUSDAY
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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]
)

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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]
)