Calculate difference between rates versus previous day

[Syndicate_Admin]

Hello community,

I'm trying to calculate the daily variation between one rate and the previous one. I'm using the formula:

Variacion_Tasa = ([Int.Pond.] - CALCULATE([Int.Pond.],PREVIOUSDAY(DIM_TIEMPO[PERIOD])))

Where Int.Pond. = DIVIDE(SUM('MIS_RATE_DETAIL_2'[BCEXRATE]),SUM('MIS_RATE_DETAIL_2'[BCE_DOP]))

However, the graph does not have the correct value:

Variation:

For July 13 for example, the variation should be 9.26 - 9.32 = -0.06

Daily rate:

I appreciate your help.

[v-rzhou-msft]

Hi @Syndicate_Admin ,

I think your measure should be correct. As far as I know, PREVIOUSDAY() should be time intellgience function, DIM_TIEMPO table should contains continuous date in it. Here I suggest you to create DIM_TIEMPO table by CALENDAR() or CALENDARAUTO() function.

DIM_TIEMPO = CALENDAR(MIN(MIS_RATE_DETAIL_2[Date]),MAX(MIS_RATE_DETAIL_2[Date]))

Data model in my Sample:

Result is as below.

Best Regards,
Rico Zhou

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

[Syndicate_Admin]

Thank you! @Syndicate_Admin

[amitchandak]

@Syndicate_Admin , Make sure DIM_TIEMPO is marked as date table

Date from DIM_TIEMPO is used in visual and slicer

The date in MIS_RATE_DETAIL_2 does not have a timestamp

and join between MIS_RATE_DETAIL_2and DIM_TIEMPO is single directional

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...