Value on the Card


#1

Hi Sam
I am calculating Customer Churn rate by each month, and want to show the latest value on the Card. Values are right for the month with 31days, but not other months.
Please see attached file Value%20on%20the%20Card

The Dax function:

Unit Churn Rate CM = 
var maxdate = Max(Dates[Date])
Return
CALCULATE([Unit Churn Rate], 'Dates'[Date] =maxdate)

Could you please help me to correct this?


#2

I don’t see an attached file unfortunately?

Can you please add to help with this solution.

Thanks