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.
I need to create a list of Architectural Sheet names based on a variable in an Excel form.
I map this variable to the field [Value]
I am able to create the desired number of rows (one for each sheet) using a custom column list, and expanding the list to rows.
= Table.AddColumn(#"Renamed Columns", "SheetCount", each {1..[Value]})
From this I am able to create a sheet list, e.g.
So far so good.
Isolated Plan Views - 1
Isolated Plan Views - 2
Isolated Plan Views - 3
Isolated Plan Views - 4
But I would also like it to increment by letter too. The new sheet name would be:
Isolated Plan Views A - 1
Isolated Plan Views B - 2
Isolated Plan Views C - 3
Isolated Plan Views D - 4
I created a second custom column list:
= Table.AddColumn(#"Renamed Columns", "SheetCount", each {"A.."D"})
but this created 16 rows, not the desired 4. Furthermore, since [Value] may vary, the above custom column assumes a static number of characters.
Please advise.
Thanks!
Solved! Go to Solution.
I figured it out.
I created another column using the ASCII value for the letter.
= Table.AddColumn(#"Added Conditional Column", "ASCII", each Character.FromNumber([SheetCount] + 64))
I figured it out.
I created another column using the ASCII value for the letter.
= Table.AddColumn(#"Added Conditional Column", "ASCII", each Character.FromNumber([SheetCount] + 64))
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |