Forum Discussion
[DAX] Format function seems not working
Dear all,
Format function seems not working like below capture screens.
Would anyone please clear which is wrong ; me or Power Bi?
Below is my purpose and problem details.
Purpose
- Want to show week numbers continued by last week of last year on X-axis (i.e. '15 W51 | '15 W52 | '16 W1 | '16 W2 )
- Try to Concatenate the Year and Week numbers for using X-axis
- Try to change Year and Week numbers to text for using Concatenate parameters
Problems
- The function Format in DAX does not work rightly like below
- Parameter "G" as General Number changes all the number to string just "G" (Figure #1)
- Parameter #### as 4 digit numbers returns error message (Figure #2)
Figure #1
Figure #2
Hi extri13,
Firstly, there are several syntax errors in your formula, please change it to the following formula.
TEST = FORMAT( [no], "General Number")
Secondly, do you want to pick the last 4 digit numbers from your column in the second screenshot? If that is the case, you can use the following formula.
Test = RIGHT( [no], 4)
However, if the above formula doesn’t meet your requirement, please describe more details about which format of data you want to return.
In addition, for more details about how to use Format function, please review the following articles.
https://msdn.microsoft.com/en-us/library/ee634924.aspx
https://msdn.microsoft.com/en-us/library/ee634561.aspx
Thanks,
Lydia Zhang
1 Reply
Hi extri13,
Firstly, there are several syntax errors in your formula, please change it to the following formula.
TEST = FORMAT( [no], "General Number")
Secondly, do you want to pick the last 4 digit numbers from your column in the second screenshot? If that is the case, you can use the following formula.
Test = RIGHT( [no], 4)
However, if the above formula doesn’t meet your requirement, please describe more details about which format of data you want to return.
In addition, for more details about how to use Format function, please review the following articles.
https://msdn.microsoft.com/en-us/library/ee634924.aspx
https://msdn.microsoft.com/en-us/library/ee634561.aspx
Thanks,
Lydia Zhang