Same month previous year with filter

[alecsio]

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

[alecsio · Accepted solution]

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

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

thank you

[alecsio]

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