DAX Measure -以文本类型输出数字

Question

我使用DAX来计算具有不同数据类型(货币、%、整数和小数)的不同值，当我输出时，我希望将所有这些数据类型输出为文本数据类型。

如何在DAX测量的最后一步执行此操作？

Answer 1

你有没有尝试过格式化功能？

https://dax.guide/format/

--  FORMAT is a formatting function that formats a value based
--  on a format string.
EVALUATE
{
    ( "Percent",      FORMAT (                0.742, "Percent" )        ),
    ( "Currency (1)", FORMAT (             1234.567, "$#,0.00" )        ),
    ( "Currency (2)", FORMAT (             1234.567, """US$"" #,0.00" ) ),
    ( "Date (1)",     FORMAT ( DATE ( 2019, 3, 28 ), "yyyy-mm-dd" )     ),
    ( "Date (2)",     FORMAT ( DATE ( 2019, 3, 28 ), "m/d/yy" )         )
}