Forum Discussion
vijenkin
Microsoft Employee
6 years agoReplace Values in Column with another Value
Hello I am currently trying to replace values in one column based on set criteria. I did some research and while I see a number of topics that talk about replacing a value in column A if value in col...
Anonymous
5 years agoNot applicable
I have a problem similar to this...but the solution does not work for me. I have a column (Projected Date) with nulls for some dates. However, I do not want to replace all nulls in the column...only nulls for Plant "A", if Status is "D". The nulls can be replaced with dates from another table. I have attached the Power BI file...and below is a "mocked up" image of what I need.
I have tried If, and LookupValue...I am just not getting the syntax correct
I would like to include examples, but I cannot see where to add the .pbix file...and if I paste the visual example, I get an error for too many rows. Please email me so I can send you [email protected]