How to create a dynamic “this week’s menu” button for your intranet

People jokingly (or not) sometimes tell me the only reason for which they use the intranet is the cafeteria menu. So on a recent draft of a redesigned homepage, I introduced a prominent "Menu" button that would always be linked…

Power BI: Calculate next year’s amount in previous year’s row

The following is a DAX formula you can use to create a calculated column that shows "next year's" value in "this year's" row. You can easily adapt this to show "yesterday's" amount or "tomorrow's" total as well. It can be…

Using today’s date and/or current time in calculated columns and list view filters

I previously shared how to create a "Today" column in SharePoint that would always be up-to-date even if list items weren't modified. These were no-code solutions that utilized either SharePoint Designer or Microsoft Flow. You can, however, use Today's date/time…

Embedding Power BI Report Server (PBIRS) reports in SharePoint

If you're on-premises and looking to embed a Power BI Report Server report in SharePoint, you'll find it's not as easy as O365 embeds. But it's certainly possible; here's how: Create a full-screen URL for the report you wish to…

How to create a powerful date table or DateKey in Power BI

DateKeys are essential for relative time measures. In "manage relationships" you tie the 'DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you're…

View and share Power BI Report Server (PBIRS) reports full screen

The O365 Power BI Service has an easy "expand" icon on reports to make them full screen whereas Power BI Report Server (PBIRS) lacks that feature. We can still view reports full screen, however, using this simple trick in the…

Use Power BI to create a dynamic/live meeting room schedule

I recently set out to create a "live" conference room schedule that could be presented constantly on an auto-refreshed screen outside conference rooms. This would replace printed schedules placed in holders outside the rooms. The following example uses a SharePoint…