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.
Hello,
This is the Record cell that is driving me crazy:
The first column (4) is variable, it can be from 1 to 11. So I want to add a new column just showing the 2nd column (3).
When I use this lookup formula I obviously get the number 3 because I insert in lookup field the number 4.
How can I solve this problem, extracting the correct answer whatever the number in the left column is?
Thanks a lot!
Solved! Go to Solution.
Thank you mate! It returns the "4" instead of the "3" (as I would prefer) but I can make some adjustments to extract the "3" number. Thanks!
Use Record.FieldNames(<record name>){0}
Thank you mate! It returns the "4" instead of the "3" (as I would prefer) but I can make some adjustments to extract the "3" number. Thanks!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |