Forum Discussion

fjcampos's avatar
fjcampos
Frequent Visitor
6 years ago

Problem in calculating the difference from the previous month

I am calculating the difference of one month with last month, I tried this solution but it shows me the following:


Using this formula always results in zero for me MOV_NETO_RRC
I would like to filter from January to April and only show me the values enclosed with blue.

The expected result is something like this:

 

Take into account that to calculate the month of January you must subtract the month of December.
My applied measure is as follows:

MOV_NETO_RRC = SUM(RRC[RESERVA_RIESGO_CURSO]) - CALCULATE(SUM(RRC[RESERVA_RIESGO_CURSO]);PARALLELPERIOD(DIM_TIEMPO[FECHA].[Date];-1;MONTH))

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi fjcampos ,

     

    You may create measure like DAX below.

     

     

    MOV_NETO_RRC =
SUM ( RRC[RESERVA_RIESGO_CURSO] )
    - CALCULATE (
        SUM ( RRC[RESERVA_RIESGO_CURSO] ),
        DATEADD ( DIM_TIEMPO[FECHA].[Date], -1, MONTH )
    )

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi fjcampos ,

         

        You may change the formula like DAX below.

         

        MOV_NETO_RRC = IF(SUM(RRC[RESERVA_RIESGO_CURSO])=BLANK(), BLANK(), SUM(RRC[RESERVA_RIESGO_CURSO]) - CALCULATE(SUM(RRC[RESERVA_RIESGO_CURSO]);PARALLELPERIOD(DIM_TIEMPO[FECHA].[Date];-1;MONTH)))

         

        If the total row is incorrect, you may create another measure except the original [MOV_NETO_RRC ] using HASONEVALUE function, and display the new measure in the Matrix visual. See the similar case .

         

        If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

         

        Best Regards,

        Amy

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.