Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |