powerbi从文本中提取想要的字段并分组

当我们建立大数据模型时，会遇到文本中出现某个词和句子时，我们就要对文本进行归类分组，我也遇到了一个类似的问题，发出来希望帮助更多的技术人员。

powerbi从文本中提取想要的字段并分组。

屏幕显示 = SWITCH(TRUE(),
CONTAINSSTRING([机器显示],"显示完美"),"显示完美",
CONTAINSSTRING([机器显示],"显示无明显"),"显示完美",
CONTAINSSTRING([机器显示],"轻微色差"),"轻微色差",
CONTAINSSTRING([机器显示],"轻微亮度"),"轻微亮度问题",
CONTAINSSTRING([机器显示],"坏点"),"显示坏点",
CONTAINSSTRING([机器显示],"透图"),"显示透图",
CONTAINSSTRING([机器显示],"色斑"),"显示色斑",
CONTAINSSTRING([机器显示],"显示不检测"),"显示异常",
CONTAINSSTRING([机器显示],"异常"),"显示异常",
CONTAINSSTRING([机器显示],"无法显示"),"显示异常",
CONTAINSSTRING([机器显示],"压伤"),"显示异常",



"其他"
)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17