Forum Discussion
Replace exact one null in column.
Hi, Edit: I described my problem incorrectly. The data source is MS SQL, after downloading the data to PowerBI, I want to do data transformation in Power Query. One of the columns has missing da...
Anonymous you can't replace it but you can add a new column in PQ or DAX with a logic that will create the column you need. The logic will require that the row will have something that will distinguish it from the other rows in your table
Are the values in the other columns unique? Meaning could you create a conditional column (either in Power Query or data view) to add in your value? Something like this: = IF( [unique column] = ABC), 25000$, [Price]
Hi Anonymous
You can try the below code, replace the table and column name with the exact name from your report.
IF(ISBLANK('Table'[Column]),"Replacement Field", 'Table'[Column])It's not what I'm looking for, but that's because I described my problem incorrectly at the begining.