Forum Discussion
Need to have blank cell if there is specific value in my cell
Hi team, Lets say I have a dataset with the following values. I want to automatically empty the cell in cell 2 or replace with 0 while the remaining cells will show 0.5 & 9.5 accordingly. I'm op...
What's wrong with Power Query? The step could be
addValue = Table.AddColumn(
Source,
"Value",
each [
n = Number.From( Text.Trim( Text.BetweenDelimiters([Data], "-", ")" )) ),
b = if List.Contains({0.5, 9.5}, n)
then n
else null][b]
)