Im Strying to single out records from out ITSM tool (ticket logging tool). I have a change Schedule table where the Start and End Date and time are recorded.
I'm looking for a way of seeing if a change is Occouring "today" to be able to filter records in a dashboard (For our Daily Operations Meetings)
The Logic IF (AND ((Starttime) => TODAY())(Endtime <= Today()),TRUE, FALSE)
This would alow me to create a dashbaord tile that i could filter today that would show changes happening today as well as long changes scheduled over several days.
I have created an additional 'Custom column' containing "DateTime.LocalNow()" but when i try and use a 'Conditional Column' to compare but the Formula window omplains the custom column is not a Date.
Im at a stuck... Help?
Thanks in Advance
Solved! Go to Solution.
Looks and Works Beautifully
= Table.AddColumn(#"Renamed Columns2", "ChangeToday", each if [Today] >= [StartDate] and [Today] <= [EndDate] then "True" else "False" )