Date calculation problem, need help

[Anonymous]

How would I solve the following?

"Anniversary",  "Date Pulled" and "Tenure Years" are "Columns" in my table 

I  will also be needing "Todays date" 

I believe I need to write a  dax measure to correctly find the correct answer  as "Todays  Date" will change based on when the user accesses the power bi dashboard.   If I used a column to contain  "Todays Date", it  would always stay the same to the date and time it was published if I understand correctly.

Here is what I am trying to do:

If "Anniversary" > "Date Pulled" and < "Todays Date"

then Tenure Years + 1 else Tenure Years 

Is there an easy answer for this ?  Thank you for any help 

[Ritaf1983 · Accepted solution]

Hi @Anonymous

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523