Not been sold last 2 years

[Anonymous]

Hello

So i have 2 diferent date columns

Im trying to figure out how to calculate, how mutch each warehouse has in stock hasent been sold the last 2 years. But not count those who has a creation date 2 years from todays date . Meaning im trying to find how mutch obsolencence mearchandise each warehouse have.

Example:

[Anonymous]

Right click on your table name and select "New column", then enter the following:

Over 2 years old = if(table[Last sold date]-table[Creation date] > 730, "Y","N")

substitute "table" with your actual table name.

Now, you will have a column telling you "Y" if there are 730 days between the two dates and a "N" if not.  Pull this column into your "Visual level filters" and select Y to see only items that are 2 years or older.

There are people on here a lot smarter than me so there might be a better way but this is how I would do it.

[Anonymous]

Hi and thank you Usates

However im getting this error with the formula

[Anonymous]

You need a comma instead of a colon in between the "Y" and "N"

.........> 730, "Y","N")