Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated table/vlookup

I am struggling with the following: I have one table (1) with deal ID's and data about related activities (one deal ID can have multiple activity IDs). I have another table (2) with deal IDs and da...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

I did't find the activity creator and the values you want to summarized in your sample data thus i couldn't image the expected result you want. However, i do think about if we could use Merge table feature or CROSSJOIN() function here.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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