Forum Discussion

JoseDavid's avatar
JoseDavid
Icon for Helper I rankHelper I
8 years ago
Solved

Problem extracting month to calculate previewsmonth

Hello everybody.

 

I´m having problems to calculate the sales amount of previews month.

 

 

I Combine the month and the Total Sales:

 

 

After that, I apply this formula:

 

Total Ventas MA = CALCULATE([Total Ventas];PARALLELPERIOD(vFrmEstadisticaFVDetalladaA[FechaFactura];-1;MONTH))

 

To calculate the previews month.

 

When I put in a table the total sales of the previews month, it´s give me te total, but no by month:

 

 

 

Can somebody help me?

 

Thank you very much!!!

jd

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Try to add ALL() to the table with the dates.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Try to add ALL() to the table with the dates.