Forum Discussion

extri13's avatar
extri13
Helper I
10 years ago
Solved

[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...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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