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.
Hi
New to Power Bi.
I have the following extract from a table
Product code Type Source
B1wp2XXXX1 pre-process J15
b1wp2XXXX1 post-process GKV 1
b1wp2XXXX2 pre-process j2
b1wp2XXXX2 post-process GKV 2
B3WP2XXXX1 pre-process j6
b3WP2XXXX1 post-process GKV 9
etc.....
So a "product code" has various "types" of process and "source". What I am after is a solution to change the "source" of the "pre-process" to corresponding "post-process" one for that product code ie for b1wp2xxxx1 J15 to GKV.
Tried various formulas, workarounds etc with no joy.
Thanks
R
Hi,
Here is how to do this with a measure:
Proud to be a Super User!
Hi Valtteri,
Thanks for the reply.
I maybe made the sample above too simple as there are many "types" to be considered and "sources"
After typing in the measure i get the error "A single value for column 'Source' in table xxxxx cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, mac, count, or sum to get a single result"
Thanks again
R
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |