How to get previous values

[NQT1711]

Hi there, 

I have a table like that:

Market_Week	Sum Quantity
2	705
3	8272
4	8285
6	8705
7	8717
8	8726
10	9211
12	40157
13	43308
15	47564
16	49146

And i want to get previous values like:

Market_Week	Sum Quantity	Previous Sum Quantity
2	705
3	8272	705
4	8285	8272
6	8705	8285
7	8717	8705
8	8726	8717
10	9211	8726
12	40157	9211
13	43308	40157
15	47564	43308
16	49146	47564

How can I handle this?

Thank you and I look forward to your support.

[DataNinja777 · Accepted solution]

Hi @NQT1711 

I am sure there are many ways to do this, but one way is to create a calculated column for the indexing by rankx, and then to create another calculated column bringing the previous row.  

Best regards,

[v-kongfanf-msft · Accepted solution]

Hi @NQT1711 ,

Creating calculated columns is indeed a good option, as @DataNinja777  provides.

However, if your data model is too large, it may increase the memory burden since the calculated columns will actually be added to the data model.

Perhaps create a measure is a good option, refer to the following formula:

MEASURE =
MAXX (
    FILTER ( ALL ( 'Table' ), 'Table'[Market_Week] < MAX ( 'Table'[Market_Week] ) ),
    [Sum Quantity]
)

Best Regards,
Adamk Kong

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

[DataNinja777 · Accepted solution]

Hi @NQT1711 

I am sure there are many ways to do this, but one way is to create a calculated column for the indexing by rankx, and then to create another calculated column bringing the previous row.  

Best regards,

[Kaviraj11]

There's two way that you can do it now. 

1. Create a Measure

var _selecteddate= FIRSTDATE('Calendar'[week])-1

var PreviousDayTotal=CALCULATE(SUM(QUANTITTY),TREATAS({_selecteddate},'Calendar'[week]))

RETURN

IF(SUM(QUANTITTY)=BLANK(),BLANK(), SUM(QUANTITTY))

2. New features

You can calculate the previous value using new calculation as well which is the prefered solution now.

Visual calculations (preview) | Microsoft Power BI Blog | Microsoft Power BI

[Wilson_]

Kaviraj11,

I strongly disagree that visual calculations are the preferred solution.

They're still a preview feature. They are also specific to the visual only and cannot be reused anywhere else.