Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Need help on below

I have a table like below Employee name Group Test Name Ramu Production Arjun Test Arjun Need a mesuare if group column will be test then employee name should be Arjun show ...

DAX

FreemanZ

2 years ago

hi Anonymous ,

try to plot the mentioned columns with a measure like:

Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    "Arjun", ""
)

Test Name = 
IF(
    MAX(data[Group]) = "Test", 
    MAX(data[Employee name]), ""
)

it worked like:

Tom_Y

Advocate II

2 years ago

Use Add Column?

Test Name = IF('Table'[Group]="Test", 'Table'[Employee], BLANK())

Anonymous

Not applicable

2 years ago

Hi Tom,

Thanks for your support

i have connected live connection .... required a DAX , so kindly please check and provide the details

Tom_Y
Advocate II
2 years ago
It's DAX. Just click "Add Column" and paste, and reivse to fit your table name/ column name..
- Anonymous
  Not applicable
  2 years ago
  Hi Tom,
  
  Thanks for your time.
  The data source are connected live data (data fabrication - dataset), after connected live data the new column option will not available ,see the below screenshot
  
  Please check and share inputs how we can go head