• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • Lingo
  • Recent
  • Shop
    • Power BI SWAG
    • Scrims
    • Layouts
    • Solutions
    • DAX Games
    • My account
      • Cart
      • Checkout
    • Terms of Use
      • General Privacy Rights
      • California Privacy Rights
      • Copyright DMCA Policy
  • Clothing
  • YouTube
  • Podcast
  • About
    • Owners
    • Contributors
  • Training
News Ticker
  • [ 2022-05-06 ] Power BI Hack: Download Report Authored in Browser as PBIX Sharing & Administration
  • [ 2022-04-30 ] Power BI Support Channel: Microsoft Teams Tips Sharing & Administration
  • [ 2022-02-10 ] 8 Mistakes I made to Start Learning Power BI Sharing & Administration
  • [ 2022-02-10 ] Certified vs. Promoted Dataset? Power BI Developers
  • [ 2022-02-03 ] Business Ops 3.0.2: Updated External Tools Building Reports
Home2016August

Month: August 2016

Custom Date Tables
Report Data Tips

Building Date Table from Scratch

2016-08-31 Mike Carlo 3

Recently at work I’ve been working with a number of large data warehouses with time series data.  Often when working on such data you need to incorporate a data calendar to compute date ranges.  So, […]

Calendars - Curbal
Report Data Tips

Make Calendars Using DAX – Curbal

2016-08-30 Mike Carlo 0

Often you will need to create some custom calendars within your PowerBI reports.  Ruth Pozuelo from Curbal does a great video tutorial on using Calendar() and CalendarAuto().  I have use the Calendar() DAX function many […]

Load Multiple Excel Files
Data Sources

Load Multiple Excel (xls or xlsx) Files

2016-08-10 Mike Carlo 17

Previously we’ve done a tutorial on loading multiple text files within one query.  This is nice, however we will also need to import multiple Excel files.  First, to understand the procedure of querying multiple excel […]

Move You Data The Easy Way
Data Preparation Tips

Using Variables for File Locations

2016-08-04 Mike Carlo 7

This week I encountered an issue when working with multiple queries in my data model.  Here is the source files in case you want to follow along. Here’s what happened.  I had a PBIX file […]

Categories
  • Articles & Opinions
  • Building Reports
  • Data Preparation Tips
  • Data Sources
  • Interesting & Fun Applications
  • News & Events
  • Performance Tips & Tricks
  • Power BI Developers
  • PowerBI.Tips Tools
  • Report Data Tips
  • Report Interactions
  • Report Visualization Tips
  • Sharing & Administration

Copyright © 2022 | MH Magazine WordPress Theme by MH Themes