• Data Platforms
    • Databricks
    • Microsoft Azure
    • Microsoft Fabric
    • Power BI
    • SQL Server
  • Data Engineering
    • Azure Databricks
    • Azure Data Factory
    • Azure Data Lake
    • Azure SQL DB
    • Azure Synapse Analytics
    • SQL Server Analysis Services
    • SQL Server Integration Services
    • SQL Server Reporting Services
  • Company
    • Microsoft Fabric Workshop
    • About
    • Blog
    • Careers
    • Industries
      • Finance
      • Healthcare
      • Manufacturing
      • Pharmaceutical
      • Retail
      • Public Sector
    • Our Team
    • Resources
      • Azure Resources
      • Case Studies
      • Power BI Demo
      • Power BI Resources
      • SSIS eBook
  • Contact Us
How to Use the SQL LEAD Window Function – LEAD with EOMONTH

How to Use the SQL LEAD Window Function – LEAD with EOMONTH

Jun 3, 2019 | Business Intelligence, Microsoft, SQL Server

By: Paul Schuliger       Over a year ago I wrote an article that discussed using the SQL Window Function ROW_NUMBER() to set up a sort order within each layer of a hierarchy, and then showed how to use that information in Power BI. I recently found...

Recent Posts

  • Key2 Consulting Partners With Databricks To Help Companies Maximize Data and AI
  • How to Build Metadata-Driven Pipelines in Microsoft Fabric
  • Getting Started With Copilot in Microsoft Fabric

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • App design
  • Application Development
  • Artificial Intelligence
  • Azure
  • Azure Cosmos DB
  • Azure Data Factory
  • Azure Databricks
  • Azure Synapse
  • Big Data
  • BIML
  • Business Intelligence
  • Careers
  • CCPA
  • Cloud Technology
  • Conferences
  • Consulting
  • COVID-19
  • Custom Development
  • Data Encryption
  • Data Governance
  • Data Management
  • Data Regulations
  • Data Security
  • Data Visualization
  • Data Warehousing
  • Databricks
  • Entrepreneurship
  • Fantasy Football
  • Featured
  • Featured
  • GDPR
  • GitHub
  • healthcare
  • Key2 Stories
  • Machine Learning
  • Microsoft
  • Microsoft Copilot
  • Microsoft Excel
  • Microsoft Fabric
  • Microsoft Power Automate
  • Microsoft Power BI
  • Microsoft PowerApps
  • Open Source
  • PowerShell
  • RevoScaleR
  • Salesforce
  • Self-Service BI
  • SharePoint
  • Snowflake
  • Software Development
  • SQL Server
  • SSIS
  • Tableau
  • Tales from Consulting
  • Tech Tips
  • Technical Information
  • Uncategorized
  • Web 3.0
  • Web Applications
  • Web design
  • Web Development
  • What's Happening at Key2
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site, you consent to our use of cookies and the terms of our Privacy Policy.Got It!