PowerPivot/PowerView/PowerQuery/PowerBI

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 21: Time Intelligence – Dates Functions: FIRSTDATE() and LASTDATE()

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces two DAX Time Intelligence functions related to the Date: FIRSTDATE(), and LASTDATE(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

5,034 reads

SQLServerCentral Article

An Introduction to Power BI

  • Article

Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]

5 (2)

You rated this post out of 5. Change rating

2021-07-12

8,289 reads

SQLServerCentral Article

Analyze Azure Cosmos DB data using Synapse Link and Power BI

  • Article

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]

You rated this post out of 5. Change rating

2021-01-12

2,627 reads

Blogs

Common Issues When Using Change Tracking for Data Warehouse Incremental Loads

By

I have a few clients that incrementally load tables from a SQL Server source...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Cool AI sites

By

As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Columnstore index record with huge delta_store_hobt_id

By Sandy67

I am a starter on the concept of indexing. I have been looking into...

Data Debt

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Debt

Visit the forum

Question of the Day

Precision and Scale I

I have this number: 456.23 What is the scale of this number?

See possible answers