| 
	     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... | |
| | | | | 
            
              www.sqlbi.com
             | 
        |
| | | | | The RANKX function in Power BI might have an unexpected behavior when applied to a column that has a specific sort order in the data model. This article exp | |
| | | | | 
            
              blog.crossjoin.co.uk
             | 
        |
| | | Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the performance of a report may be different there compared to in Power BI Desktop. Following on from this,... | ||