| 
            
            
              About the Power Query category
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            2051
           | 
          
            November 12, 2019
           | 
        
        
          | 
            
            
              Extended Date Table (Power Query M function)
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            231
           | 
          
            122384
           | 
          
            October 22, 2025
           | 
        
        
          | 
            
            
              Power Query - Multiple excel sheets in one file
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            72
           | 
          
            October 7, 2025
           | 
        
        
          | 
            
            
              Power Query - connect to Dataset Tables
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            715
           | 
          
            September 19, 2025
           | 
        
        
          | 
            
            
              Recursive calculation Food supply
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            9
           | 
          
            100
           | 
          
            August 29, 2025
           | 
        
        
          | 
            
            
              Unpivoting multiple alternate rows
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            7
           | 
          
            92
           | 
          
            August 11, 2025
           | 
        
        
          | 
            
            
              Replace blanks in dataset - best practice?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            252
           | 
          
            July 2, 2025
           | 
        
        
          | 
            
            
              Extended Date Table with 4-4-5 fiscal model
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            90
           | 
          
            June 23, 2025
           | 
        
        
          | 
            
            
              Transform a table
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            128
           | 
          
            March 6, 2025
           | 
        
        
          | 
            
            
              Retain ability to join after reshaping dimension tables
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            89
           | 
          
            March 5, 2025
           | 
        
        
          | 
            
            
              Get transformation rules from a Mapping table
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            122
           | 
          
            February 13, 2025
           | 
        
        
          | 
            
            
              Data Structure Reshaping Challenge
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            102
           | 
          
            February 4, 2025
           | 
        
        
          | 
            
            
              Two new columns different positions
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            11
           | 
          
            171
           | 
          
            January 21, 2025
           | 
        
        
          | 
            
            
              How to connect Magento ecommerce database with Power BI
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            8
           | 
          
            1633
           | 
          
            January 15, 2025
           | 
        
        
          | 
            
            
              Data Extraction & Storage
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            1558
           | 
          
            December 13, 2024
           | 
        
        
          | 
            
            
              Transform PDF Journal Entry to an excel file in Powerquery
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            18
           | 
          
            194
           | 
          
            December 10, 2024
           | 
        
        
          | 
            
            
              Disable background refreshes?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            413
           | 
          
            December 8, 2024
           | 
        
        
          | 
            
            
              PQ displaying 0 or 1 rather than true or false
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            110
           | 
          
            November 26, 2024
           | 
        
        
          | 
            
            
              Test Filters in M Code
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            129
           | 
          
            November 25, 2024
           | 
        
        
          | 
            
            
              Extended Date Table
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            10
           | 
          
            1823
           | 
          
            November 1, 2024
           | 
        
        
          | 
            
            
              How to achieve this data view from the given report
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            79
           | 
          
            October 31, 2024
           | 
        
        
          | 
            
            
              ODBC connection error
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            212
           | 
          
            October 24, 2024
           | 
        
        
          | 
            
            
              Transform data which has multiple columns with the same name but different values
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            122
           | 
          
            October 21, 2024
           | 
        
        
          | 
            
            
              Finding the first and last rows in a non contiguous list
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            93
           | 
          
            October 8, 2024
           | 
        
        
          | 
            
            
              Best Practice for Handling Period Based Data in Fact Tables
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            209
           | 
          
            September 16, 2024
           | 
        
        
          | 
            
            
              Where to store source data?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            838
           | 
          
            September 11, 2024
           | 
        
        
          | 
            
            
              Lookup a Value in a different table and return a value from another column
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            122
           | 
          
            August 27, 2024
           | 
        
        
          | 
            
            
              Geospatial Functions
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            130
           | 
          
            August 20, 2024
           | 
        
        
          | 
            
            
              Determine a lookup key or match for another table
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            70
           | 
          
            August 20, 2024
           | 
        
        
          | 
            
            
              Fill in Records for Missing Dates
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            90
           | 
          
            August 18, 2024
           |