如何使用Power BI DAX从移动表计算每天的库存？

Then I would plug the above data into the Date context and count the number of IDs from the above table, where the "TimeStamp of 'B' breached" value is smaller AND the "TimeStamp of next status breach" value is greater than the certain date.

不幸的是，我不确定如何将此逻辑插入DAX语法中，因此任何建议都会受到赞赏。

Unfortunately I am not sure how to plug this logic into DAX syntax, hence any recommendations would be appreciated.

非常感谢！ Gergő

Thanks a lot! Gergő

这有点棘手，但是我们可以使用临时计算的汇总表来做到这一点在一个度量范围内：

This is a bit tricky, but we can do it with the use of a temporary calculated summary table within a measure:

首先，我们创建一个汇总表来计算最后一个 TimeStamp ，每个 ID 值。为此，我们在过滤表上使用 SUMMARIZE 函数，在该表中，我们仅考虑来自当前日期或更早的日期，并按 ID ，并计算出最大值 TimeStamp 。

First, we create a summary table which calculates the last TimeStamp for each ID value. To do this, we use the SUMMARIZE function on a filtered table where we only consider dates from the current day or earlier, group by ID, and calculated the max TimeStamp.

一旦我们有了最大值对于当日每个 ID 的时间戳记，我们可以查看 Status 的状态

Once we have the maximum TimeStamp per ID for the current day, we can look up what the Status is on that day and add that as a column to the summary table.

一旦我们知道每个对象的最新状态，就将其添加到摘要表中。当天的 ID ，我们只需要总结状态为的状态 B 并忽略其他内容。

Once we know the most recent Status for each ID for the current day, we just need to sum up the ones where that Status is "B" and ignore the other ones.

阅读度量可能更容易如果我们将其分解为多个步骤。逻辑与以前相同，只是使用变量更清晰。

It may be easier to read the measure if we break it up into steps. Here's the same logic as before, but using variables for more clarity.