Forum Discussion
logic for dates calculation dax
Im looking for a way to create a logic that if the dates are in the last 90 days it returns "last 90 days", else
it returns the "last 2 years" dates (including the 90 days). I have a date table upto current date that im using.
The issue currently is that my regular if else statement will exclude the 90 days when returning the last 2 years the
Any suggestions appreciated!
1 Reply
Hi,@Black_Mamba
how do you display the result? for example: if it displayed in the column, current date is 2018-08-21, so when date is 2018-08-20,
it returns "last 90 days" and "last 2 years"? it can't achieve, So could you show us what do you want to apply it?
please share detail steps for us to reproduce the issue.
You can share some data sample and the formula and the expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
