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…

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…

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…