/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

gqbi.wordpress.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...
3.4 parsecs

Travel
| |
| | azurecloudai.blog

Analyzing the usage and tuning resources is a key responsibility in Cloud Management. We need to understand where we spent , what are the trends and where we can tune our spending. When it comes to analyzing Azure usage Microsoft offers different tool set with different capabilities; Cloudyn New Azure Cost Management Azure Consumption API...
3.5 parsecs

Travel
| |
| | 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...
1.8 parsecs

Travel
| |
| | 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...
4.3 parsecs

Travel
|