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...
CalculatedColumn=VAR _c=Data[Company Name] RETURN IF(COUNTROWS(FILTER(Data,Data[Company Name]=_c&&Data[Productcode] IN {"car","pen","pencil"})),"Yearly",Data[Plan frequency])
