Praise from VB

Our awards and notification system stopped working and Todd immediately came to help repair the issue to team members can receive their awards updates.

Missing Stop Sign

Started using the system that the City has for reporting issues.  It is clunky, but a means, I suppose.

The first request was for the Stop sign that has been missing for the last few years, ever since someone ran it down.  I also turned in a couple of street lights that were out over by the community center.

Request: The STOP sign for southbound traffic on N.K was damaged in an accident a few years ago and was never replaced ... not sure if that is by design, but it continues to create hazardous conditions for those traveling east-west on NW.Terr.

Someone from their office responded today, after about a week.

I have reviewed the City's traffic code and there is no ordinance for a stop sign at this location. I will review the area to see if a stop sign is warranted.

I have no idea what this person is talking about.  There has been a stop sign there for the last 50 years, until that accident.  

Create a Due Date based on a Date

Yet another Power Query note for Power BI. 

I have a string of dates in which I need to create a due date as the 5th of the following month.

In Power Query,

1. Choose the Date Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Month > Month
2. Go to the formula box and change
1. "Month" to "NextMonthDate"
2. "Date.Month([Date]" to "Date.AddMonths([Date],1"
3. Change NextMonthDate column to a Date type, if is not already
4. Choose the NextMonthDate Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Month > Month
5. Add Column Tab
1. Custom Column
1. Name = Fifth
1. = 5
6. Choose the NextMonthDate Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Year > YEar
7. Select Columns for Month, Fifth, Year
1. Transform to Text type
8. Add Column
1. Custom Column
1. Name = "DueDate"
2. [Month]&"/"&[Fifth]&"/"&[Year]
9. Select DueDate Column
1. Transform to Date type

There may be a more effective way, but this method seems to work perfectly.

Doing Nothing to Achieve Everything

Doing and Demanding

"Damning the system is trite and only serves to further dependency.

Doing and demanding are more liberating."

- me