But some few rows come with date in march although the majority had dates in April for exemple. This help exactly, thank you very much !īut I have the same problem with the Month.name column, which might have the same value for each row of the same Source.name file. I hope I have been clear, you can see a screenshot in the attached file. I just want to replace the value "null" in each file by the value of the Office of the file. My formula will read like this : If value of column Office is "null" replace "null" by the value in column Office for the same "source.name" if not "null" then return the same Office value. (I don't know exactly which method would work). There will be the sames files added to the folder monthly and I want to replace in each file some values based on the below formula or by adding a custom column. I have combined two csv files from a folder and have made some tranformations. I am stuck on a transformation in Power Query and need your help. ![]() You can simply add a custom column with the following code : ![]() Subject: Replace value based on the content of another column ( custom column and if satement)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |