/explore
|
You are here 
|
azurecloudai.blog | ||
| | | | |
blog.crossjoin.co.uk
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I'll show you a different trick that - when you can use it - can give you an equally significant performance boost. When you merge... |
|
| | | | | ||
| | | | |
ruiromanoblog.wordpress.com
This is nothing new and as already been blogued by Chris Webb and Matt Masson: https://cwebbbi.wordpress.com/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/ But based on their work a made a new one with some new quickwins: Suport for the day of the week start (in Portugal tipicaly starts on monday not sunday) Only StartDate is mandatory, in this case a... |
|
| | | | | ||
| | | | |
ginameronek.com
Ever had report usage dataand needed to figure out which day of the week is quietest so you can do maintenance? Want to visualize spikes in sales activity based on hour ranges within the day? Need a date or time dimension for a proof of concept in Power Pivot before you bother to spin up... |
|
| | | | | ||
| | | | |
code.krister.ee
Me and my partners agree that me going off and doing some startup team is not a recipe for success. One person just can't think of everything and one just needs to bounce off ideas and think of more options than the one brain can handle. A less apparent surprise |
|
| | | |||
