Archive for 2019

Power BI - Column for data from previous date

In Power BI, I needed to add a column for data from a previous date, not Today()-1. Since this was pulling data from a directory that migh...

Many times you want to build your own date table in Power BI to show a date range. This is the DAX expression that I used to build that, ...

The other day I wanted to test out something in SharePoint 2016, but I didn't have a test environment.But I also didn't want to te...

You can color code your list rows of a SharePoint list by using this code. Insert a script editor webpart, paste in this code, and change ...

Recently I had a service on a server that keeps stopping, and I needed to check to make sure it's started, and if not then I need to r...

This Powershell script will give you the size of all user's mailboxes. Save this to a .ps1 and run it Get-MailboxStatistics -Serve...

Here was my problem: I installed SCSM 2019 and installed the web portal on the same SCSM app server. During the install I chose to use htt...

The normal way of adding Trusted Sites to IE through group policy will lock down adding trusted sites so users cannot add their own. And e...

This device collection query will give you all computers with a specific Windows 10 build number. Replace the build number to get version ...

I recently had to find all computers that do not have the latest client version installed on them, so that I can get them updated to the m...

SharePoint 2013/2016 took away the ability to sign in as a different user. Even opening an InPrivate window doesn't get around single...