Forum Discussion
Date calculation problem, need help
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
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
1 Reply
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