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

[Vinay07]

Hi All,

I am trying to calculate the month's different count when the Interest rate changes from Previous interest to Current interest changes. Please help

Here Interest rate = INIT_DPOS_INT_PCT

Below is the screenshot for reference

Calculations need to be worked on the DAX column dynamically. Below is an example of Previous interest to Current interest month's difference count. 

[tamerj1]

Hi @Vinay07 
Not sure if I correctly understand the requirement but you may try

Difference Count =
CALCULATE ( DISTINCTCOUNT ( 'Table'[INIT_DPOS_INT_PCT] ), ALLSELECTED () )

[Gabry]

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