/explore
|
You are here 
|
blog.crossjoin.co.uk | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
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. |
|
| | | | | ||
| | | | |
curatedsql.com
[AI summary] A blog post discusses troubleshooting an error when connecting SQL Profiler to a SQL Server Premium Per User (PPU) dataset, providing a solution for the 'race with the ID' error. |
|
| | | |||
