Forum Discussion

ahhollan's avatar
ahhollan
Icon for Helper I rankHelper I
6 years ago
Solved

Add values in visual as column in new table

I have one visual that shows # of items per month based on a count.  I have a new table with another type of items/month. I need to add the values from the visual as data in a new column in the new t...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ahhollan 

 

You can just manage the relationship between these 2 tables if they have common ItemID/Month:

Then you can add the count column directly:

Alternatively, you can use the RELATED function: https://docs.microsoft.com/zh-cn/dax/related-function-dax

Here's post for your reference: https://community.powerbi.com/t5/Desktop/Lookupvalue-lt-searchvalue-gt-is-a-value-in-the-current-row/td-p/790977

 

please kindly mark the answer as a solution if it helps. thanks a lot!