Forum Discussion
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...
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.
