有2種方法
1.在小于10的月份前郁轻，人為加了個(gè)0
monthformat2 =
IF ( 'Table'[Month] < 10, "0" & 'Table'[Month], CONVERT ( [Month], STRING ) )
- 將月份數(shù)字的顯示格式修改了文留，顯示為01，實(shí)際上還是1
monthformat =
FORMAT ( INT ( 'Table'[Month] ), "0#" )
dax格式相關(guān)參考:
https://www.xspdf.com/resolution/52666397.html
https://community.powerbi.com/t5/Desktop/How-to-format-text-in-PoewrBI/m-p/399628#M182477
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
https://community.powerbi.com/t5/Desktop/Expressions-that-yield-variant-data-type-cannot-be-used-to/m-p/332281
