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, I want to add a numerical value to year groups and registration groups. As it doesn't like nursery and reception labeling.
For example:
Year group column
00N = -1
00R = 0
1 = 1
etc
Reg group column
F3 = 7
L4 = 8
etc
Also is there a way to tell a column with blanks to show a certain word, for instance, I'd like my blank cells to display 'unknown'.
Thank you in advance for any help you may be able to give.
Create a new column with DAX (or conditionally through Power Query). With DAX it will be something similar to:
Year group column = SWITCH( TRUE (), TableName[ColumnWithYourValues] = "00N", -1, TableName[ColumnWithYourValues] = "00R", 0, TableName[ColumnWithYourValues] = "1",TableName[ColumnWithYourValues]= BLANK(), "Unknown")
Just be careful that if you use the Unknown label, your numerical values (-1,0,1, etc.) must be string format.
Any additional condition you can write it in the Switch statement, the syntaxis would be Expression (Column Name evaluated against something), Result, ...)
Proud to be a Super User!
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |