DAX for days of the year include "0"

[matrix_user]

Hello,

I am looking for a dax expression (to include in calculated column) that will include the first nine days of the year with "0" prefix. 01, 02, 03 etc.

Thank you in advance.

[VahidDM · Accepted solution]

Hi @matrix_user 

Check this link:
https://community.powerbi.com/t5/Power-Query/change-number-format-in-query-editor/td-p/1576461

and you can find the days number and then change the format to have "0" prefix. 01, 02, 03 etc.

New Number = FORMAT('Table'[Column1], "00")

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube