Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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. 

 

"DAX help"
'Need help' 'DAX'
DAX
DAX Date condition

2 Replies

  • Gabry's avatar
    Gabry
    Super User
    2 years ago

    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

  • tamerj1's avatar
    tamerj1
    Community Champion
    2 years ago

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

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