[DAX] Format function seems not working

[extri13]

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

 

[Anonymous · Accepted solution]

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