Forum Discussion

ArashZ's avatar
ArashZ
Icon for Helper I rankHelper I
3 years ago

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...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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])

ArashZ's avatar
ArashZ
Icon for Helper I rankHelper I
3 years ago

wdx223_Daniel 

 

Thank you, but the solution doesn't work. The table still shows some monthly values.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, ArashZ 

    If wdx223_Daniel 's formula doesn't work, can you show relevant screenshots to further investigate what's causing the error?

    Also, check if the bias in the results is caused by errors in the data itself.

    Best Regards,
    Community Support Team _ Eason