Forum Discussion

alecsio's avatar
alecsio
Regular Visitor
8 years ago
Solved

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

 

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

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

     

    thank you

2 Replies

  • alecsio's avatar
    alecsio
    Regular Visitor

    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's avatar
    alecsio
    Regular Visitor

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

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

     

    thank you