Hello Experts,
I have a YearMonth dimension which I use in a chart to calculate the count of loans which statis is Recovered and it works fine with the below expression.
count({$<vLastFctBalanceExtended.LoanStatus ={'Recovered'}>}distinct LoanKey)
But I want to check how many loans has converted to status Recovered in that YearMonth and not the total starting from Jan.
Can someone help me with this please
Thanks a Lot in advance,
