Forum Discussion
calculated column
Hi, I have a table like the below: There are some companies on the table and each one sells different products. As can be seen, in the table, if the product code is glasses or shipping or additi...
Hi ArashZ
I think this is what you are looking for...
Plan Frequency Modified =
var _isinlist = CALCULATE(COUNT('Table'[Productcode]),CONTAINSROW({"car","pen","pencil"},'Table'[Productcode]),FILTER(ALLEXCEPT('Table','Table'[Company Name]),'Table'[Company Name] = EARLIER('Table'[Company Name])))
return
if(_isinlist >=1,"Yearly", "Monthly")
Hope this helps!
Thanks,
AnthonyJoseph
Thanks, but I received this error.
A single value for the column company name in the table cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation to get a single result.
Hi ArashZ
Would you be able to share the DAX that you tried so that I can see if there are any syntatical errors.
Thanks,
AnthonyJoseph