Forum Discussion

kkjj's avatar
kkjj
Frequent Visitor
4 years ago

Divide by area

Hi   I am new to Power BI and would appreciate any help.    I have the following tables.      I would like to sum the [Calculated emissions t (CO2)]based on the BU and then d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi kkjj 

Thank you for reaching out to our community and welcome! 

 

If the Hotel column and the CZBU column have the same 'names" values, then go ahead and create a relationship  between the Hotel column, and the CZBU column.  From there you can divide by Area.  

 

Hope this helps! if not, send me a DM on the community and i would be happy to help you further!

 

Best, 

Kelly Kaye

  • kkjj's avatar
    kkjj
    Frequent Visitor
    4 years ago

    Hi Kelly

     

    That didn't work. I still  get an error. 

    But I don't want to sum the area. I just want to divide each entry in the large table by the corresponding. 

     

    Thanks for your help.