cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Same month previous year with filter

Hi

I need your help to find a solution to work around this problem. I've checked already in the community but I couldn't find any real solution. Scenario:

- Table A: Date Table (Complete Date, Day, Month, Year...)

- Table B: Sales

- Slider date filter on date table in relationship with the date of the sales table

I'm trying to study the sales of the period I choose in the filter compared to the one of the same period of the previous year. In addition I created a new measure that says the forecast sales to the end of the month and I would like to compare it to the sales of the same month of the previous year creating a new measure.

What I obtained is the total amount of the sales of the previous year. I have no problem to have the sales of the exact period of the previous year but I have problem to have the total sales of the entire month of the previous year.

I hope it's clear.

This is the formula that gives me the total sales of the previous year to which I need to add the filter of the month.

`FatturatoAnnoPrecedenteTotMese= CALCULATE(SUM(ALESSIO_MX_MOVIMENTI_CLIENTI[TotDoc]);ALLEXCEPT(ALESSIO_MX_MOVIMENTI_CLIENTI;ALESSIO_MX_MOVIMENTI_CLIENTI[AGENTE]);ALESSIO_MX_MOVIMENTI_CLIENTI[CSG_DOC_ORI]="BC"||ALESSIO_MX_MOVIMENTI_CLIENTI[CSG_DOC_ORI]="FT";PREVIOUSYEAR(ALESSIO_MX_MOVIMENTI_CLIENTI[DTT_DOC_ORI]))`

Let me know if there are other ways to have the same result.

Thank you to all

Alessio

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

## Re: Same month previous year with filter

Ok I think I've found a solution such as:

PARALLELPERIOD(DateDimension[Date];-12;MONTH))

thank you

2 REPLIES 2
Frequent Visitor

## same month last year with date filter

Hi

I need your help to find a solution to work around this problem. I've checked already in the community but I couldn't find any real solution. Scenario:

- Table A: Date Table (Complete Date, Day, Month, Year...)

- Table B: Sales

- Slider date filter on date table in relationship with the date of the sales table

I'm trying to study the sales of the period I choose in the filter compared to the one of the same period of the previous year. In addition I created a new measure that says the forecast sales to the end of the month and I would like to compare it to the sales of the same month of the previous year creating a new measure.

What I obtained is the total amount of the sales of the previous year. I have no problem to have the sales of the exact period of the previous year but I have problem to have the total sales of the entire month of the previous year.

I hope it's clear.

This is the formula that gives me the total sales of the previous year to which I need to add the filter of the month.

`FatturatoAnnoPrecedenteTotMese= CALCULATE(SUM(ALESSIO_MX_MOVIMENTI_CLIENTI[TotDoc]);ALLEXCEPT(ALESSIO_MX_MOVIMENTI_CLIENTI;ALESSIO_MX_MOVIMENTI_CLIENTI[AGENTE]);ALESSIO_MX_MOVIMENTI_CLIENTI[CSG_DOC_ORI]="BC"||ALESSIO_MX_MOVIMENTI_CLIENTI[CSG_DOC_ORI]="FT";PREVIOUSYEAR(ALESSIO_MX_MOVIMENTI_CLIENTI[DTT_DOC_ORI]))`

Let me know if there are other ways to have the same result.

Thank you to all

Alessio

Frequent Visitor

## Re: Same month previous year with filter

Ok I think I've found a solution such as:

PARALLELPERIOD(DateDimension[Date];-12;MONTH))

thank you