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

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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]
)