Using a single row value in a column to populate a new column

[Sedos101]

Hi Everyone

I was wondering how to do this in Power BI.

Basically I have a column which has a row that contains a certain value that I want to use to populate another column entirely. For example below:

Can someone please tell me the power query to do this or if there are options within the menu?

Thanks in Advance

[Dinesh_Suranga · Accepted solution]

@Sedos101 ,

Hi
Try following M code

if Text.End([#"Date/Time"] , 2) = "PM" or Text.End([#"Date/Time"] , 2) = "AM" then null else [#"Date/Time"]

Then Fill Down.

Thank you.