Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
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.
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.
Dear @v-xicai I shared an example of my data. Can you help me solve the problem?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |