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:

but when i click the "Edit Queries" i cant see my "no of yrs" column that i just created .
Need help please, sorry not really sure about Power BI yet. Thank u

Need Help

8 Replies

  • stvsurf's avatar
    stvsurf
    Resolver I
    6 years ago

    Depending on the way your column should work or which calculation you want to perform, you can create them in:

    1/ in Power BI (with DAX), what I believe you did

    2/in Power Query (with M), you end up in Power Query if you click "Edit Queries" in Power BI

     

    All columns you create in power query end up in Power BI (assuming you enable load), but the extra columns you create in Power BI don't end up in Power query because it's the layer below.

    • 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
        Resolver 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.