Forum Discussion

PeraZo's avatar
PeraZo
Icon for Helper I rankHelper I
5 years ago
Solved

How to create new column that get value from previous row (previous date)

Hi,   Can someone kindly help me adding new column ("Sales Previous Day ") that gets value from previous row (or previpus day, week, year)?   The table data is below. I want to get sales number ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    PeraZo 

    You can try this as a new column:

    Previous Day Sales = 

CALCULATE(
    SUM(Table2[Sales]),
    LASTDATE(
    FILTER(
        ALL(Table2[Date] ),
        Table2[Date] < EARLIER([Date]) 
        )
    ), 
    ALLEXCEPT(Table2,Table2[Store ID])
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

PeraZo 

You can try this as a new column:

Previous Day Sales = 

CALCULATE(
    SUM(Table2[Sales]),
    LASTDATE(
    FILTER(
        ALL(Table2[Date] ),
        Table2[Date] < EARLIER([Date]) 
        )
    ), 
    ALLEXCEPT(Table2,Table2[Store ID])
)