Difference between the Months different count when Interest rate changes from Previous to Current.

Hello,

not sure to have understood. Did you just need to calculate the difference between 2 dates?

There's a DAX formula.

Difference Count = DATEDIFF (last_inst_captil, last_update, month)

If it not works in a measure you can just add SELECTEDVALUE

like this:

Difference Count = DATEDIFF (SELECTEDVALUE(last_inst_captil),SELECTEDVALUE( last_update), month)

Please let me know if this solves you problem, if so please mark as accepted solution

bye