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,
I have a single column as follows (numbers simplified):
100,000,000
200,000
200,500
201,000
201,500
101,000,000
202,000
202,500
203,000
I would like to create a new column, that duplicates the 9 figure number in the same row that they appear in the above column. So it would look like:
Column A Column B
100,000,000 100,000,000
200,000 null
200,500 null
201,000 null
201,500 null
101,000,000 101,000,000
202,000 null
202,500 null
203,000 null
These numbers are representative and actually represent codes (these are not actually used as numerical values). The 6 figure numbers are essentially subcodes of the 9 figure number. The idea is the then to Fill Down these larger figures. Maybe there is a way to get to that point directly? I figure there is some kind of way to put together a function that goes something like, "If Column A is greater than/contains X, then column B equals Y (in the same row), otherwise, null".
Thank you in advance
Solved! Go to Solution.
Thank you for your response. This is exactly what I asked for.
Is there anyway to make it return null (ie. no value) as opposed to "null" so I can use Fill Down?
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.