Hello, i have a topic which seems to be quite simple, at least i hope so, I have two tables, please see samplefile.
table “items” contains: items, item-Groups and age of the item
table “table” contains item-group and classification-groups
so what i would like to achieve, preferrably in a calculated column, is to return the column Name, based on itemsgroup and age of days, if above very aged, then “spoiled”
e.g. "if beer is 48 days old, it is “aged”, beause it is above 30 and below 60
thanks in advance for your help, kind regards
samplefile.pbix (40.5 KB)