Solved: Re: ITSM Tool reporting - Change Schedule If TODAY...

peterdeacon · ‎02-06-2017

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

parry2k · ‎02-06-2017

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎02-06-2017

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

peterdeacon · ‎02-06-2017

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

parry2k · ‎02-06-2017

Glad it worked out, this is how we all learn

Cheers,

P

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

peterdeacon · ‎02-06-2017

Looks and Works Beautifully

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

ITSM Tool reporting - Change Schedule If TODAY falls between dates

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly