replace null

[Anonymous]

Hello all,

I have one table below and I would like to change FlowAvg to null when description_id is 43, how should I replace the value with a filter?

Thanks in advance if you could help for answering this question.

[Tahreem24 · Accepted solution]

@Anonymous 

Try below DAX Column:

Column = IF(Table[DescriptionID]=43,BLANK(),Table[FlowAvg])

[amitchandak]

@Anonymous , go to data transformation mode/edit query mode. Right click on column there is an option for replacing value.

Use  null for null and replace it with the value you want.

https://www.youtube.com/watch?v=UZQ9EFvEECY