/explore
|
You are here 
|
ginameronek.com | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
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. |
|
| | | | | ||
| | | | |
www.desertislesql.com
With the general availability release of Fabric in November 2023, I am dedicating several posts to the features that are only in Fabric and not anywhere else. The first feature is Direct Lake. Dire... |
|
| | | |||
