Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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?
Solved! Go to Solution.
@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
@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
Create calculate column and use either Related or RelatedTable function.
User | Count |
---|---|
59 | |
22 | |
18 | |
16 | |
15 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |