Customizations in SharePoint are always an interesting topic. Many clients remember the days of legacy SharePoint on-prem (2007, 2010,2013), where it was almost impossible to do anything in SharePoint without customizations. Some clients have started with SharePoint Online (MS 365) but have a desire to have customizations to provide a truly unique solution to their organization. If you ask Imaginet, “Should we customize in SharePoint Online,” our answer is generally “no.”







Business responses to COVID-19 have created a rapid shift to work from home and/or remote working. This has quickly affected all industries and has provided challenges for some organizations that were historically “onsite” focused. The past month at Imaginet we have had almost zero impact to our operations due to 1) most of our client projects are done remotely, 2) most of our employees are used to delivering quality work from home/remote, and 3) we…


Power Query Function for Dense Ranking Recently I was having issues writing a measure in DAX to rank items properly (not an issue with the DAX, but in my understanding of the DAX). I did some searching and came across Chris Webb’s article that had a nice implementation of ranking using Power Query. The technique he proposed uses Power Query to: sort a table by the column you want to rank by, add an index column…