Forum Discussion

Sedos101's avatar
Sedos101
Icon for Helper I rankHelper I
3 years ago
Solved

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

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 exa...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    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.

     

     

     

Dinesh_Suranga's avatar
Dinesh_Suranga
Icon for Continued Contributor rankContinued Contributor
3 years ago

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.