Forum Discussion
Helper IIChanging blank values with no data to a different value
I am creating a training matrix in Power Bi. I have some trainings that get assigned to certain people but not others. If the box is blank, it means the person was not required to take the training. To avoid confusion, I would like to block out the blank boxes or use a DAX expression that will transform these values to something like "not required." I am not sure, however, how to manipulate the underlying data to achieve this. A screenshot of the matrix is below. Thank you in advance!
Hi ld17 ,
If the field [(ENV) Environmental Training] is a fact field in the table, you create a calculated column as below to change the blank values. Otherwise, please provide the formula if it is a measure or calculated column. Thank you.
Column = IF ( 'Table'[(ENV) Environmental Training] = BLANK (), "not required", 'Table'[(ENV) Environmental Training] )Best Regards
2 Replies
FreemanZSuper User
is (ENV) Environmental Training a measure?
Hi ld17 ,
If the field [(ENV) Environmental Training] is a fact field in the table, you create a calculated column as below to change the blank values. Otherwise, please provide the formula if it is a measure or calculated column. Thank you.
Column = IF ( 'Table'[(ENV) Environmental Training] = BLANK (), "not required", 'Table'[(ENV) Environmental Training] )Best Regards