Forum Discussion
Create Table based on columns and measures
Community, I need a little help!
Is there any way to create a table based on a column and a measure? Let me explain the case:
I have a PRODUCTS table with a column called family_name. Each product has its own family. Ex:
| product | family_name |
| 1 | AAA |
| 2 | AAB |
| 3 | AAC |
| 4 | AAD |
| 5 | AAE |
I have a measure that CALCULATE the Time to Win for each opportunitie on table OPPORTUNITIES. Ex:
Now, I wloud like to generate a table like this:
| family_name | Time to Win |
| AAA | 5 |
| AAB | 10 |
| AAC | 15 |
| AAD | 20 |
| AAE | 25 |
I have tried to aproach using SUMMARIZE, ADDCOLUMN but I couldn´t figure out how to do it. Any help?
EvertonRosa , if you create calculated table, the measure can not take slicer value and calculation may not go as planned and will be static
Add a new column, using addcolumns, and use related , relatedtable, or simple max function work across the table
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
3 Replies
EvertonRosa , if you create calculated table, the measure can not take slicer value and calculation may not go as planned and will be static
Add a new column, using addcolumns, and use related , relatedtable, or simple max function work across the table
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Thanks, amitchandak. I found a solution after watch your videos.
