Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |