Forum Discussion
Dynamic Year Calculation
Hello, I am trying to create a measure that calculates the number of years between two dates based on a value.
I have been using the following measure:
Years C = if([Value] <=0, 0, (([Date] - DATE(2016, 12, 31)) / 365))
However, I would like to modify this so that when the value is greater than 0, that date is pulled instead of Dec 31, 2016.
So for example, if the value of June 30, 2017 starts to be a positive number, I would like the calculation to be ([DATE] - June 30, 2017) /365.
How can I code this so that the measure is dynamic?
Thank you very much
2 Replies
ARob198 Hard to tell without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi ARob198
Is this logic correct?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
