Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 ))
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |