|
You are here |
azurecloudai.blog | ||
| | | | |
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... | |
| | | | |
blog.gbrueckl.at
|
|
| | | | | [AI summary] The article explains how to calculate ISO 8601 week numbers and years in DAX and Power Query for data modeling. | |
| | | | |
tracyboggiano.com
|
|
| | | This month's T-SQL Tuesday is brought to us by Jason Brimhall. We are writing about times someone took chances with the databases that the DBAs felt were not worth it. I am going to talk about taking chances with your backups, our #1 job as DBAs is to have backups. Let's start with the scenario. | ||