Forum Discussion
Related with IF Statement
Hi , I have 2 related tables (*-1): Table A Host Device IP Host1 vmk0 IP1 Host2 vmk0 IP2 Host3 vmk0 IP3 Host4 vmk0 IP4 Host5 vmk0 IP5 Host6 vmk0 IP6 Hos...
Hi Anonymous ,
If you need a calculated column, here is one of the ways:
IP VMK0 = VAR IPVMK = "vmk0" VAR t = FILTER ( TableA, TableA[Device] = IPVMK && TableA[Host] = TableB[Host] ) RETURN MAXX ( t, TableA[IP] )IP VMK1 = VAR IPVMK = "vmk1" VAR t = FILTER ( TableA, TableA[Device] = IPVMK && TableA[Host] = TableB[Host] ) RETURN MAXX ( t, TableA[IP] )
ERD
Community Champion
Community ChampionHi Anonymous ,
If you need a calculated column, here is one of the ways:
IP VMK0 =
VAR IPVMK = "vmk0"
VAR t = FILTER ( TableA, TableA[Device] = IPVMK && TableA[Host] = TableB[Host] )
RETURN
MAXX ( t, TableA[IP] )IP VMK1 =
VAR IPVMK = "vmk1"
VAR t = FILTER ( TableA, TableA[Device] = IPVMK && TableA[Host] = TableB[Host] )
RETURN
MAXX ( t, TableA[IP] )Thank you for your prompt reply.