|
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... | |
| | | | |
martinschoombee.com
|
|
| | | | | 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... | |
| | | | |
devinknightsql.com
|
|
| | | | | A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here's some of the quick benefits and reasons why you need a date table: Helpful when filtering data Filter by year, quarter, month, etc... Helpful for drilling into a hierarchy of... | |
| | | | |
tsqltuesday.com
|
|
| | | [AI summary] The blog post discusses SQL Server bugs and enhancements, encouraging readers to report issues through Microsoft's Connect platform and participate in the improvement process. | ||