历史维度表

历史维度表 = SELECTCOLUMNS({

(1,"日",1,"每日"),

(2,"周",7,"每周"),

(3,"月",30,"每月"),

(4,"年",365,"每年")

},

"序号",[Value1],"维度",[Value2],"天数",[Value3],"name",[Value4])

日月周年按天数排序

动态=

var normaly="暂无"

var dayly="暂无"

var weekly="暂无"

var monthly="暂无"

var yearly="暂无"

return SWITCH(TRUE(),

SELECTEDVALUE('历史维度表'[name])="日",dayly,

SELECTEDVALUE('历史维度表'[name])="周",weekly,

SELECTEDVALUE('历史维度表'[name])="月",monthly,

SELECTEDVALUE('历史维度表'[name])="年",yearly,

normaly

)

忘记从哪复制的了，保留个笔记