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
stvsurf's avatar
stvsurf
Resolver 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. 😞

  • stvsurf's avatar
    stvsurf
    Resolver I
    6 years ago

    No worries, can you explain what you want to achieve with this conditional column and which condition you want to put in it.

    I was trying to address the question on why it wasn't in Power Query and tried to help you to get that, but with some extra information, it could be that you don't even need it in power query.

     

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    The calculated columns and measures created in Power BI Desktop doesn't show on the Power Query data table, it is by default.

    Could you show detailed reuqirements of these columns so that i can create custom column in Power Query instead?

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.