Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter Costs by Region, or Update Query Data with Proper Costs Column

Hi Everyone,   I could use some help in figuring out how to best find the aggregate costs of goods sold based on region.   Say a good costs $1 in the US, $2 in Europe, and $3 in Asia. Each specif...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Actually I think I figured it out.

     

    Just needed to click the add column tab in the query editor. Then create a new conditional column.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Amy

 

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

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the post link.

 

To clarify, i'd like to have a new column that maps the appropriate cost based on region for each row. 

 

As in,

 

            Region | Cost

Row 1 |        US | $1

Row 2 |        AP | $3

Row 3 |        EU | $2

 

Since i do not have the data structured in that way at the moment. 

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Actually I think I figured it out.

     

    Just needed to click the add column tab in the query editor. Then create a new conditional column.