/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

devinknightsql.com
| | ruiromanoblog.wordpress.com
1.3 parsecs away

Travel
| | 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...
| | martinschoombee.com
1.8 parsecs away

Travel
| | Unless your source data contains no dates at all, every Power BI model should have a Date entity. Chances are good that you've ignored a built-in option in Power BI Desktop that's enabled by default (image below). While the "Auto Date/Time" option isn't the worst thing you could do in Power BI Desktop (i.e. the...
| | blog.crossjoin.co.uk
1.7 parsecs away

Travel
| | There are hundreds of different methods for generating a Date dimension table for use in Power Pivot: you can use TSQL, Excel formulas, import from the DateStream table in the Windows Azure Marketplace, and there's even an app for it. Nevertheless I thought it would be a good idea to solve this problem in Power...
| | www.codeofhonor.com
36.1 parsecs away

Travel
| Anyone who runs a web site knows that they're constantly under attack. You only have to look at your log files to know that hackers running site-scanners are constantly hitting your servers looking for unpatched vulnerabilities to exploit. One of the servers I wrote for Guild Wars 1 - named AcctHttpSrv - was designed to [...]