Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to find a renewal rate of customers who are renewing there account. With the data I am given I am given a expiration date and an invoice date. For my formula I want to capture the COUNT of accounts that are up for renewal in the past 6 months. Meaning if TODAY is 6 months from the expiration date I have the output value needs to be 1. I am using a measure but it is not working. Where am I going wrong ?
I want the output to be 1 if an account's expiration date is 6 months away from today. Capturing accounts 6 months away from their expiration date.
Hi, @tyannamorrison
Have you check you data type of your filed [expiration_date] ?
Please make sure that there is no comparison between text data and date data.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Getting this error upon implemnting this measure.
@tyannamorrison , Try a new measure like
6Months =
var _max = today()
var _min - date(year(_max), month(_max) -6, Day(_max))
return
CALCULATE(SUM('License Table'[expiration_date]),filter('License Table','License Table' [expiration_date] >=_min && 'License Table' [expiration_date]<=_max ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |