- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add date to calculated measure.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
)
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
)
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!
Proud to be a Super User!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
08-08-2024 04:59 AM | |||
05-29-2024 09:01 PM | |||
07-22-2024 11:52 AM | |||
03-12-2024 11:06 AM | |||
Anonymous
| 01-24-2023 07:51 AM |
User | Count |
---|---|
95 | |
71 | |
44 | |
38 | |
29 |
User | Count |
---|---|
156 | |
92 | |
61 | |
44 | |
42 |