Replacing dates by word

Power Query
1

Hi all,

I am looking to replace my dates (any date in the column) to the word “After BM”.

Screenshot attached. Can you help?

Capture
Capture426×692 37.7 KB

1 Like
2

Hi @judith_nigge is there some logic to Before BM?

1 Like
3

Hi Davie,

Thanks for your quick reply.

“Before BM” is the replacement for all rows without dates - those ones gave an error. I copy the code here:
= Table.ReplaceErrorValues(#“Changed Type2”, {{“Before & After Benchmark”, “Before BM”}})

Now I need to change all dates to “After BM”. As I want them to appear as one only column in the visuals and not with different dates. I attach another screenshot:

image
image2144×98 37.8 KB

Thanks for your help in advance!
Judith

4

Hi Judith,

try this step - adjust the previous step name and it should work:

= Table.ReplaceValue(prevStep, each [#"Before & After Benchmark"],each if [#"Before & After Benchmark"] <> "Before BM" then "After BM" else "Before BM",Replacer.ReplaceValue,{"Before & After Benchmark"})

Regards,
Matthias

3 Likes
5

@judith_nigge the solution @Matthias has suggested was what I was going to suggest. It should fulfill your needs if we’ve understood correctly.

Thanks

David

6

Thank you very much, Matthias! I will try it out now :slight_smile:

7

Hi Matthias,

I receive this error. I have tried to change it up, but cannot find the solution. Would you have another idea?

image
image2406×341 64.1 KB

8

Hi Judith,

seems like a copying mistake. Could you try to copy the line once more in one portion.
And do make sure that to change the prevStep portion with Replaced Errors.

Regards,
Matthias

9

Hello @judith_nigge,

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark his answer as the SOLUTION.

Thank you

10

Hello @judith_nigge ,

Just following up if the response above help you solve your inquiry?

We’ve noticed that no response was received from you on the post above. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

11

Hi @judith_nigge ,

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!