表:表有字段From_Date,Week_Code (1-7)
需求:添加切片器WEEKDAY显示值Monday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday。选择Monday时,显示每月最后一个礼拜一的数据。
实现方式一:
1,·添加计算列 weekday1,表达式如下:
Weekday1 = IF('Bonus'[WEEK_CODE]="7","Sunday",
IF('Bonus'[WEEK_CODE]="6","Saturday",
IF('Bonus'[WEEK_CODE]="5","Friday",
IF('Bonus'[WEEK_CODE]="4","Thursday",
IF('Bonus'[WEEK_CODE]="3","Wednesday",
IF('Bonus'[WEEK_CODE]="2","Tuesday",
IF('Bonus'[WEEK_CODE]="1","Monday",
"Blank"
)))))))
2, 将weekday1 设置为切片器后,排序乱了
解决:选择字段,点击按列排序,选择Week_Code,保存后切片器按1-7排序
实现方式二:
添加计算列weekday2,表达式如下:
weekday2 = Format('Bonus'[FROM_DATE],"DDDD")
效果与方式一一样。
但是这个表达式不适用于直连模式
下面是大神给的一张格式转换表。太游泳了。。。
感谢所有指点小萌新的大神们。。。