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, […]
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 […]
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 […]
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 […]
Copyright © 2023 | MH Magazine WordPress Theme by MH Themes