DAX度量值-将数字输出为文本类型

Question

我使用DAX计算不同数据类型(货币、%、整数和十进制(的不同值，当我输出这些数据时，我希望将所有这些数据类型输出为Text数据类型。

如何在DAX测量的最后一步中做到这一点？

Answer 1

是否尝试FORMAT函数？

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" )         )
}