本文介绍了如何计算 Power BI 中的累计次数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
假设我有一张这样的桌子:
Let's say I have a table like this:
column1 Column2 A 01/01/2020 B 01/01/2020 C 04/01/2020 A 07/01/2020 B 07/01/2020 A 12/01/2020 C 10/01/2020我要做的是计算 column1 中的值发生了多少次.所以我希望能够以这样的方式结束:
What I am trying to do is count how many times a value in column1 has occurred. So I want to be able to end up with this:
column1 Column2 column3 A 01/01/2020 1 B 01/01/2020 1 C 04/01/2020 1 A 07/01/2020 2 B 07/01/2020 2 A 12/01/2020 3 C 10/01/2020 2我发现 DAX 可以计算一个值总共出现了多少次,但我似乎找不到如何累计计算它们.提前致谢.
I found DAX to count how many times in total a value occurs but I can't seem to find how to count them cumulatively. Thanks in advance.
推荐答案逻辑同累积和,只是用 COUNT 代替:
The logic is the same as with a cumulative sum, just with COUNT instead:
column3 = CALCULATE ( COUNT ( Table1[column1] ), ALLEXCEPT ( Table1, Table1[column1] ), Table1[Column2] <= EARLIER ( Table1[Column2] ) )另请参阅:累积总 DAX 模式
按分组的不同列的累积和日期和过滤方式不同
更多推荐
如何计算 Power BI 中的累计次数?
发布评论