Forum Discussion
Solved
Custom Format each row based on column
I have data in the below format with the columns 'Metric', 'Actual Value' and 'Metric Format'. Based on the column 'Metric Format', I would like to populate the column 'Desired Outcome' in the visual...
The below code worked:
Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])
The below code worked:
Desired Outcome = if( Not(ISERROR(value('TableName'[Actual Value]))), format(value('TableName'[Actual Value]),'TableName'[Metric Format]),'TableName'[Actual Value])