包括保存在日期切片器输出中的重复发生时间 [英] Including Re-occurring Time Saved in Date Slicer Output
问题描述
我正在研究利用PowerBI来确定由于各种项目而节省的时间。人们会将项目添加到Sharepoint列表中，然后馈入PowerBI。
项目表：
Project Tite ，描述，已保存的小时/月数，开始日期，结束日期，重复吗？ （T / F）
[某些项目仅节省固定的10个小时左右的时间，其他项目每月节省时间（由重复列表示）]
我创建了两个度量， RUNTIME 确定项目在几个月内运行了多长时间（（TodayDate- StartDate）/ 30）以及 TIMESAVED ，即从该特定项目节省的总时数（RUNTIME * Hours /节省了一个月）。
虽然可行，但它有一个很大的限制。选择范围时，例如说01/01/2017-01/01/2018，开始日期早于该范围的所有项目都将被排除。但是这些可能还在进行中，这意味着需要增加该项目在范围内节省的时间。
我试图找到解决方案，但是我一直被困在要求切片器的过滤日期，但是我不确定这是可能的。我需要那些具有持续储蓄的项目也要把在此期间的储蓄也计算在内。
可能的选择也许是每月创建一个月/年列/年，每列有一个自定义公式，用于确定该月/年的项目节省的小时数，但是这似乎效率不高，此时返回Excel可能会更好。
任何想法/建议将不胜感激，目前正在尝试解决任何想法，但仍然需要过滤器指定的值。提前为解决此问题的建议而欢呼：）
另请参见：
您可以使用
I am looking into utilising PowerBI to identify time saved due to various Projects. People will add the projects to a Sharepoint List which then feeds into PowerBI.
PROJECTs Table:
Project Tite, Desc, Hours/Month Saved, StartDate, EndDate, Repeat? (T/F)
[Some Projects only save a fixed 10 or so hours, others save time per month (indicated by the Repeat Column)]
I've created two measures, RUNTIME determining how long the project has run in months ((TodayDate - StartDate)/30) as well as TIMESAVED which is the total hours saved from that specific project (RUNTIME*Hours/Month Saved).
Whilst this works, it has a pretty big limitation. When selecting a range, say 01/01/2017 - 01/01/2018, any projects with a start date before that range are excluded. However these maybe on-going, meaning the time saved by this project during the range needs to be added.
I've attempted to find a solution to this, however I keep getting stuck at requiring the the filter dates from the slicer, however I'm not certain this is possible. I need those projects with on-going savings to have the savings during the period given to be counted as well.
Possible alternative maybe to create a Month/Year column per Month/Year with a custom formula per column to determine that projects Hours saved for that Month/Year however this seems inefficient, at that point back to Excel might be better.
Any ideas / suggestions would be greatly appreciated, currently running through any ideas to solve but keeps coming back to needing that value specified by the filter. Cheers in advance for any advice tackling this :)
You can use Timeline Storyteller. you can create your time line and add a couple Slicers for Start and End. It will split by day the dates and you won't miss any data.
这篇关于包括保存在日期切片器输出中的重复发生时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
