FIND 提取姓名

2020-06-01 22:26:44 ⋅ 1749 ⋅ 0 ⋅ 0

file
结果会是这个样子的:
file
dax 如何写 :

=var  a = FIND(",",'表1'[Name],,0)
var b = FIND(",",'表1'[Name],a+1,a)
return MID('表1'[Name],b+1,LEN('表1'[Name]))&" "&LEFT('表1'[Name],a-1)

是不是很简单呀

自由转载-非商用-非衍生-保持署名（创意共享3.0许可证）