Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Column when creating a new column

Hi, So i have a new column that is not inside in my actual table so i want to do a conditional column but couldn't find my "new column" that i just created.  here's my new column: bu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for the reply, yeah so my worries is since i can't find the "no of yrs" in my power query as i want to do a conditional column. What can i do then?

here's my table inside the power query that doesn't include my new added "no of yrs" . Not really sure on how to do this inside the power query as because in power bi desktop i cant see the conditional column

stvsurf's avatar
stvsurf
Icon for Resolver I rankResolver I
6 years ago

Anonymous  Can you create the column in Power BI again, and just before you finish creating it take a screen shot of the formula.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here's the column that i created, (it's inside the BI desktop not in BI Query)

    • stvsurf's avatar
      stvsurf
      Icon for Resolver I rankResolver I
      6 years ago

      Assuming you have the column [no of mths] in Power Query available, you can try this formula

       

      if Number.RoundUp([no of mths]/12,0) > 10 then " >Yr 10" else Text.Combine({"Yr ",Number.ToText(Number.RoundUp([no of mths]/12,0))})

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi both no of months and no of yrs are new columns that i created in power bi desktop hence when i check inside the power query i can't find either one of them. 😞