Explore >> Select a destination
|
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... | |
| | | | |
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... | |
| | | | |
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... | |
| | | | |
curatedsql.com
|
|
| | | [AI summary] A collection of SQL-related blog posts from January 4, 2024, discussing topics like data manipulation, database management, and SQL Server features. | ||
