Forum Discussion

siva54's avatar
siva54
Helper I
4 years ago
Solved

Asset Description with same class

Hi Team,   I need a calculated column for the below criteria.   we have differnent asset classes with different asset description with their codes. Here, For Example:- Asset Description are{ F...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    siva54 

    Add the following column:

    Check = 

VAR _DES = Table1[Asset Description]
VAR __CLASS = Table1[Asset class]
VAR _CODE = Table1[Code]
VAR _LIST = CALCULATETABLE( VALUES(Table1[Code]), Table1[Asset Description] = _DES , Table1[Asset class] <> __CLASS, REMOVEFILTERS( ) )
RETURN
    IF ( _CODE IN _LIST , "ANAmoly" , "Not An" )

     



Fowmy's avatar
Fowmy
Super User
4 years ago

siva54 

Add the following column:

Check = 

VAR _DES = Table1[Asset Description]
VAR __CLASS = Table1[Asset class]
VAR _CODE = Table1[Code]
VAR _LIST = CALCULATETABLE( VALUES(Table1[Code]), Table1[Asset Description] = _DES , Table1[Asset class] <> __CLASS, REMOVEFILTERS( ) )
RETURN
    IF ( _CODE IN _LIST , "ANAmoly" , "Not An" )