Author Archives

I am a software engineer, business and systems analyst, program manager, and technical architect with a passion for delivering business strategy and technology. Over the past 15 years I have partnered with dozens of employers and clients to achieve goals across the corporate landscape.

• SharePoint – Issue with Hidden Title Column and Quick Edit Mode for Lists

  By Christopher Brotsos on April 17, 2019 • ( 0 )

  

  I ran into an unexpected issue today working in Quick Edit mode on a SharePoint List. Specifically, I couldn’t add new items based on a custom content type where I’ve hidden the Title column. Quick Edit is requiring a value… Read More ›

• Power BI – Sales and Expense Report – Negative Numbers with DAX CONTAINSSTRING

  By Christopher Brotsos on April 10, 2019 • ( 1 )

  

  When looking at sales income versus expense values in Microsoft Power BI, you can easily turn expense / cost values into negative numbers using DAX formulas. I’ll demonstrate a scenario using CONTAINSSTRING to convert numerical values imported from Microsoft Excel… Read More ›

• Power BI – Sales and Expense Reports – Prepare Excel Tables from Office 365 SharePoint

  By Christopher Brotsos on April 10, 2019 • ( 1 )

  

  Power BI can connect to Microsoft Excel files in your Office 365 SharePoint sites to produce powerful reports. You can then publish those reports and create dashboards using the Power BI Service in Office 365. In this first of two… Read More ›

• Microsoft Project – Change Project Start Date and Move Deadlines

  By Christopher Brotsos on April 8, 2019 • ( 0 )

  

  Microsoft Project has a few ways to update a project start date, but if you have Task Deadlines, your project schedule could incur an unwanted side effect if you don’t choose the right method for making the project start date… Read More ›

• Microsoft Excel – Quick Day Trading Averages using NETWORKDAYS

  By Christopher Brotsos on April 8, 2019 • ( 0 )

  

  This is a post on how to use NETWORKDAYS in Microsoft Excel to help you track your average profits over your total number of trading days. In practice, Microsoft Excel is a great tool for tracking your day trading gain/loss… Read More ›

• Microsoft Excel – Profit and Loss Reporting with INDIRECT and VLOOKUP Functions

  By Christopher Brotsos on April 6, 2019 • ( 3 )

  

  The Microsoft Excel INDIRECT and VLOOKUP functions can be used together to help you analyze profit and expense data for your projects. I’ll demonstrate how these functions can be combined to help you break that analysis up by month and… Read More ›

• Power BI – Sales Invoice Reports with Filled Map, Slicers, and Report Level Filters

  By Christopher Brotsos on April 5, 2019 • ( 0 )

  

  Creating Sales Invoice Reports using Power BI is a straightforward concept, but it comes with some quirks when you actually go to build the report and evaluate the results. I’ll build a visual report in this post using the Filled… Read More ›