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
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?