admin管理员组

文章数量:1355710

I have a Fact table which has many rows, with a StatusFrom (e.g. 2025-03-17 12:54:55) and StatusTo (e.g. 2154:01:01 00:00:00) and I am looking to select ONLY the rows where SELECTEDDATE (+23:59:59) is between StatusFrom and StatusTo. This FACT is a fact showing the status changes for a case over a period of time, and we only want to see the status's as at 23:59:59 of whichever selected date we use, so we can look at this retrospectively too.

I have followed all of the tutorials and cannot get anything to work as planned.

I have got this far:

Is Date Between Status 2 =
VAR SelectedDate = SELECTEDVALUE('Dim Date'[Date])  -- Get the selected date from the slicer or context
VAR DateTimeAtMidnight = SelectedDate + TIME(23, 59, 59)  -- Combine the date with '23:59:59' time
RETURN
IF (
    DateTimeAtMidnight >= SELECTEDVALUE('Fact Device Status'[StatusFromDateTime]) &&
    DateTimeAtMidnight <= SELECTEDVALUE('Fact Device Status'[StatusToDateTime]),
    1,  -- Returns 1 if the selected date (with '23:59:59' time) is between StatusFrom and StatusTo
    0   -- Returns 0 otherwise
)

but it returns this data when selected today: Maverikk_0-1743145083647.png.

DimDate is joined to Fact on Date = StatusFromDate. I guess I am doing something wrong but need some direction please.

本文标签： powerbiJoin DimDate to Fact where DateTime is inbetween StatusFrom and StatusToStack Overflow

版权声明：本文标题：powerbi - Join DimDate to Fact where DateTime is inbetween StatusFrom and StatusTo - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744039638a2580425.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。