/explore
|
You are here 
|
www.thebiccountant.com | ||
| | | | |
blog.crossjoin.co.uk
If there's one feature of Power Query that's guaranteed to get Excel users very, very excited indeed it's the ability to combine data from multiple workbooks into a single table. The bad news is that this is something that Power Query can't do through the user interface (although so many people have asked for it... |
|
| | | | | ||
| | | | |
devinknightsql.com
A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here's some of the quick benefits and reasons why you need a date table: Helpful when filtering data Filter by year, quarter, month, etc... Helpful for drilling into a hierarchy of... |
|
| | | | | ||
| | | | |
eriksvensen.wordpress.com
Many blogposts has been written about how you can create a generic date table in your Power Pivot / Power BI datamodels. Here is a few examples https://blog.crossjoin.co.uk/2013/11/19/generating-a-date-dimension-table-in-power-query/ http://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/ http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/ https://www.powerquery.training/portfolio/dynamic-calendar-table/ But my challenge with these has always been that I had to specify from date and to date either in a worksheet, text file... |
|
| | | | | ||
| | | | |
ssbipolar.com
Late last year I was spending some vacation days playing with one of my favorite personal data sets[1], and I realized I needed a better date dimension. So I asked for one. A bunch of folks from the Power BI community shared their favorite Power Query date dimension queries[2] - you can look at the... |
|
| | | |||
