Imke Feldmann ImkeF

## power-query-iso-week-year.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                ImkeF
                / power-query-iso-week-year.md
            
            
              Created
              March 9, 2018 13:49
                — forked from r-k-b/power-query-iso-week-year.md
            
              
                M functions to convert between ISO 8601 Week & Year ⇄ dates (e.g., `2014-12-29` ⇄ `"2015-W01-1"`)
              
          
        
      
        
  
      
    based on https://en.wikipedia.org/wiki/ISO_week_date#Calculating_the_week_number_of_a_given_date
M / Power Query doesn't have a native ISO8601 Week Number function, and DAX's
weeknum(x, 21) doesn't give the correct ISO Week-Year.
Date → ISO Week

/*
based on <https://en.wikipedia.org/wiki/ISO_week_date#Calculating_the_week_number_of_a_given_date>