cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
peterdeacon Frequent Visitor
Frequent Visitor

ITSM Tool reporting - Change Schedule If TODAY falls between dates

Hi all, 

 

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

 

Pete

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: ITSM Tool reporting - Change Schedule If TODAY falls between dates

Not sure if you did this, after you added custom column, please change the data type to Date and then test.

 

dtype.PNG

 

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




4 REPLIES 4
Super User
Super User

Re: ITSM Tool reporting - Change Schedule If TODAY falls between dates

Not sure if you did this, after you added custom column, please change the data type to Date and then test.

 

dtype.PNG

 

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




peterdeacon Frequent Visitor
Frequent Visitor

Re: ITSM Tool reporting - Change Schedule If TODAY falls between dates

Such a novice Error... Apologies.  I needed to remove the Time Stamps from the dates, thank you.

 

Super User
Super User

Re: ITSM Tool reporting - Change Schedule If TODAY falls between dates

Glad it worked out, this is how we all learn Smiley Happy

 

Cheers,

P





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




peterdeacon Frequent Visitor
Frequent Visitor

Re: ITSM Tool reporting - Change Schedule If TODAY falls between dates

2017-02-06 21_28_56-Ops Dashboard - Power BI.png

 

 

Looks and Works Beautifully

 

= Table.AddColumn(#"Renamed Columns2", "ChangeToday", each if  [Today] >= [StartDate] and [Today] <= [EndDate] then "True" else "False" )