Forum Discussion
skv17
Helper II
Helper IICheck if Asset is in a Location between two dates
ok I have a table "Fleetsu Time Asset In Fence" and has columns Ctc_FleetNo,Entered_EventDateStamp , Exited_EventDateStamp and FenceName and the DateDIM table has date column , I need to know what ...
Hi skv17
You can consider to remove the relationship, then create the following measure
Measure 2 = CALCULATE(SUM('Table'[Sum of Duration in Fence Minutes]),FILTER('Table','Table'[Entered_EventDateStamp]<=MAX('Date'[Date])&&'Table'[Exited_EventTimeStamp]>MAX('Date'[Date])))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
skv17Helper II
Helper II| Date | Day of Year | FiscalMonth | FiscalMonthLong | MonthYear | MonthYearLong | Quarter | MonthYearNum | Week of Year | WeekDate | MonthNum | MonthLong | Month | FutureDate | Flag_YTD | Flag_QTD | FiscalYear | FiscalQuarter | Flag_MTD | FiscalMonthNum | CurYearOffset | CurWeekOffset | CurrentDayOffset | CurMonthOffset | CurFiscalYearOffset | CurQuarterOffset | Weekday | WeekdayNum | WeekdayWeekend | WeekSequenceNum | Year |
| ######## | 247 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -9 | 0 | 0 | 0 | Mon | 0 | Weekend | 5 | 2023 |
| ######## | 248 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -8 | 0 | 0 | 0 | Tue | 1 | Weekday | 5 | 2023 |
| ######## | 249 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -7 | 0 | 0 | 0 | Wed | 2 | Weekday | 5 | 2023 |
| ######## | 250 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -6 | 0 | 0 | 0 | Thu | 3 | Weekday | 5 | 2023 |
| ######## | 251 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -5 | 0 | 0 | 0 | Fri | 4 | Weekday | 5 | 2023 |
| ######## | 252 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -4 | 0 | 0 | 0 | Sat | 5 | Weekday | 5 | 2023 |
| ######## | 253 | Sep | September | Sep-23 | Sep-23 | Q3 | 202309 | 37 | ######## | 9 | September | Sep | Past | YTD | QTD | FY24 | FQ1 | MTD | 3 | 0 | -1 | -3 | 0 | 0 | 0 | Sun | 6 | Weekend | 5 | 2023 |
skv17Helper II
Helper IIthis is the date table
Hi skv17
You can consider to remove the relationship, then create the following measure
Measure 2 = CALCULATE(SUM('Table'[Sum of Duration in Fence Minutes]),FILTER('Table','Table'[Entered_EventDateStamp]<=MAX('Date'[Date])&&'Table'[Exited_EventTimeStamp]>MAX('Date'[Date])))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.