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...
"DAX help"
'Need help' 'DAX'
DAX
DAX Date condition
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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 () )