Forum Discussion

Anonymous

Not applicable

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 t...

Tips and Tricks

Icon for Community Support rank

Community Support

6 years ago

Hi Anonymous ,

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.

Anonymous
Not applicable
6 years ago
Thank you v-xicai for your answer, but the result is the same.
- v-xicai
  Community Support
  6 years ago
  Hi Anonymous ,
  
  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.
  - Anonymous
    Not applicable
    6 years ago
    Thanks for your answer v-xicai .
    I attach an example file of how is my model Pbix
    With your measurement I don't get a total result.