cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Impactful Individual

## How to create expression for last 2 month sales ?

1 ACCEPTED SOLUTION
Super User

@Paulyeo11  , YTD was other topics or

You can have rolling of any months by replacing values

Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,MONTH))

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

5 REPLIES 5
Super User

do you only consider month? Since i see you circle all Oct and Nov sales amount for both 2019 and 2020.

if I did not misunderstand your request. you can try this

``````Measure 2 =
VAR _max=max('SALES'[date])
VAR last1=month(_max)-1
VAR last2=month(_max)-2
RETURN CALCULATE(sum(SALES[sales]),FILTER(SALES,month(SALES[date])in {last1,last2}))
``````

Proud to be a Super User!

Impactful Individual

Hi Ryan

Amit expression working fine

I make some mistake in the image , I only refer to same year

Super User

@Paulyeo11 , Try rolling formula, With date table

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

If means every month will display 2 months of data '

In case you want two month with any selected date -https://www.youtube.com/watch?v=duMSovyosXE

Impactful Individual

Hi Amit

what i need is create a expression for compute last X month . I have change the expression from 12 to 11 , i hope to get YTD sales. Hope you can help me.

Super User

@Paulyeo11  , YTD was other topics or

You can have rolling of any months by replacing values

Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,MONTH))

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))