Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Column created on DAX not visible in Power Query

Hello,

I have created a column A in TABLEX via DAX on power bi but  when i go on the "transform data" tab (power query), i can't see the column A in my TABLEX.

Is this normal? 

Need Help

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    According to your description, you first need to confirm your connection mode. Because in direct query mode, they can only refer to the values of other columns in the same table without using any aggregation functions.

     

    Alternatively you can further describe your requirements, provide the relevant test data model (remove sensitive information) and the desired results. It is convenient for me to solve it for you as soon as possible.

    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Columns created in DAX will not be visible in power query .

    Power Query is the data preparation layer. and the output of that is used by DAX. Not vice versa

     

    Try to create same column in power query If  possible 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Then, How can i please translate this formula created in DAX on power query? 

       

      N = VAR _a =

          CALCULATE (

              CALCULATE (

                  MAXX ( Data, Data[A] ),

                  TREATAS (VALUES( Data[A] ), 'Data-CMDB'[B])

              )

          )

      RETURN

          IF ( ISBLANK ( _a ), "YES", _a )

       

      I don't know how to use a related column of table X in another table Y