Forum Discussion

ilTac's avatar
ilTac
Frequent Visitor
4 years ago
Solved

Conditional Column Power Query (M): how to repeat the value for some rows and then change the value

Hi everyone, i'm trying to achieve the follow in power query:   here's what i have as native database   and this is what i wolud like: so basically take one value from first column a...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi ilTac ,

     

    Try to add a column with the following code:

    if (try Date.FromText([Date]) otherwise null) = null then [Date] else null

    Then do a fill down on that new column

  • ilTac's avatar
    ilTac
    4 years ago

    Hi MFelix 

    i dind't know about the fill down option.

    Thank you very much, solved.

MFelix's avatar
MFelix
Super User
4 years ago

Hi ilTac ,

 

Try to add a column with the following code:

if (try Date.FromText([Date]) otherwise null) = null then [Date] else null

Then do a fill down on that new column

  • ilTac's avatar
    ilTac
    Frequent Visitor
    4 years ago

    Hi MFelix 

    i dind't know about the fill down option.

    Thank you very much, solved.