topic Difference between the Months different count when Interest rate changes from Previous to Current. in DAX Commands and Tips

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

Anonymous — Tue, 26 Mar 2024 07:51:36 GMT

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.

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

Gabry — Tue, 26 Mar 2024 09:51:53 GMT

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

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

tamerj1 — Tue, 26 Mar 2024 10:26:57 GMT

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

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