Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is it possible to add a date to this measure? I need to see the retention rate show for a full year Jan 2024 to Dec 2024.
Solved! Go to Solution.
Hi,
Does this measure work?
2024 Retention % =
CALCULATE(
DIVIDE(AISCVGP[Total Bound (Active)], AISCVGP[Total Available]),
FILTER('AISCVGP', [ACSTA] IN {"ACT", "CAN", "CLO", "LER", "NON", "PEN"}),
FILTER('AISCVGP', [ACNOR] = "R"),
FILTER('AISCVGP', [ACPROD] IN {"APL", "CPA"}),
DATESBETWEEN('Calendar'[Date], DATE(2024,01,01), DATE(2024,12,31))
)
I tried to create a visual that shows year (2023) over year (2024), and my measure is not producing the correct %.
My current measure for 2024 is below. I only really need just this measure "Retention Rate = DIVIDE(AISCVGP[Total Bound (Active)],AISCVGP[Total Available])" with a date. I'm going to remove the filters.
Hi,
Does this measure work?
2024 Retention % =
CALCULATE(
DIVIDE(AISCVGP[Total Bound (Active)], AISCVGP[Total Available]),
FILTER('AISCVGP', [ACSTA] IN {"ACT", "CAN", "CLO", "LER", "NON", "PEN"}),
FILTER('AISCVGP', [ACNOR] = "R"),
FILTER('AISCVGP', [ACPROD] IN {"APL", "CPA"}),
DATESBETWEEN('Calendar'[Date], DATE(2024,01,01), DATE(2024,12,31))
)
Thanks for your reply!
if you have a date taable and that date link to a date in your table thaat hold the retention date, then all you need to do is filter on the current year.
Unless I misunderstanding what you are asking. Can you share what you are doing? you can add the date but one would need to understand what you have in your model.
Proud to be a Super User!
User | Count |
---|---|
94 | |
79 | |
74 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |