Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculated Column

Can i create a calculated Column in Power Bi using col from diff tables ?

Example - I have sales data in table1 

and i have cost data in table2

Can i calculate Revenue from these two measures ? 

 

Both the tables are joined based on order id

Need Help

4 Replies

  • jaideepnema's avatar
    jaideepnema
    Solution Sage
    4 years ago

    Hi Anonymous ,
    Why do you want to create a calculated column ? Cant a measure work in this case ?

    Additionally can you please help with some sample data to look into your query ?

     

    Regards,

    Jaideep Nema

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Jaydeep

      I dont want an aggregarted value, I want it corresponding to certain other parameters.

       

      Like if you consider the same example given above, I may need revenue wrt each sector or region etc. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You might be able to create calculated column based on columns from different tables, but it's not supported to create calculated column based on measures.

    If you need help with DAX formula, please show some sample data and expected result to us.

     

    Best Regards,

    Jay