Power BI中不含周末的月份的日期排名
Power BI中不含周末的月份的日期排名
提问于 2021-10-12 15:07:02
我正在寻找一种DAX方法来在我的表中有一个列，它对应于不带周末的DAY()函数。在法国，周末是星期六和星期天。
如下所示：
Date|Month|Year|Rank of the day with weekend days|Rank of the day without weekend days
01/10/20201|10|2021|1|1
02/10/20201|10|2021|2|1
03/10/20201|10|2021|3|1
04/10/20201|10|2021|4|2
05/10/20201|10|2021|5|3回答 1
Stack Overflow用户
发布于 2021-10-12 15:31:11
使用DAX计算列
在dataset本身中需要有以下两列
| Date | Day# | Week# | Ranking |
|---------------------------- |------ |------- |--------- |
| Friday, October 1, 2021 | 6 | 40 | 1 |
| Saturday, October 2, 2021 | 7 | 40 | 1 |
| Sunday, October 3, 2021 | 1 | 41 | 1 |
| Monday, October 4, 2021 | 2 | 41 | 2 |
| Tuesday, October 5, 2021 | 3 | 41 | 3 |
| Wednesday, October 6, 2021 | 4 | 41 | 4 |
| Thursday, October 7, 2021 | 5 | 41 | 5 |
| Friday, October 8, 2021 | 6 | 41 | 1 |
| Saturday, October 9, 2021 | 7 | 41 | 1 |
| Sunday, October 10, 2021 | 1 | 42 | 1 |
| Monday, October 11, 2021 | 2 | 42 | 2 |
| Tuesday, October 12, 2021 | 3 | 42 | 3 |比如
Day# =
WEEKDAY ( 'Table'[Date], 1 )
Week# =
WEEKNUM ( 'Table'[Date] )
Ranking =
VAR _week =
CALCULATE ( MAX ( 'Table'[Week#] ) )
VAR _rank =
RANKX (
FILTER (
ALL ( 'Table' ),
'Table'[Week#] = _week
&& EARLIER ( 'Table'[Day#] ) <> 6
&& EARLIER ( 'Table'[Day#] ) <> 7
),
'Table'[Date],
,
ASC
)
RETURN
_rank
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/69542899
复制相关文章
相似问题
腾讯云开发者
