/explore
|
You are here 
|
devinknightsql.com | ||
| | | | |
gqbi.wordpress.com
I have been working on some new projects and one of the things that I found that was whilst you can find examples of creating Date tables, I could not find any examples of where the Date table included Fiscal Attributes such as Fiscal Month, Fiscal Quarter and Fiscal Year. So in this blog post... |
|
| | | | | ||
| | | | |
blog.crossjoin.co.uk
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... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
www.chantifiedlens.com
In this post I want to cover using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. |
|
| | | |||
