Power BI

External Article

Scientific Calculations in Power BI - Cube, Square, Logarithms, Powers, Inverse and more

  • Article

Microsoft Power BI Desktop provides users with multiple ways to help shape and transform their data. One of the options users have is scientific calculations, which support operations like cube, square, logarithms, etc. Power BI has this option in the Power Query Editor mode, where the user can easily apply one of these transformations for any number-based columns. In this tip, we will overview this utility in Power BI and how to benefit from it.

2024-02-14

Stairway to DAX and Power BI

Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions

  • Stairway Step

Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). 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-24

2,038 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions

  • Stairway Step

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-09-27

1,072 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions

  • Stairway Step

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-08-30

970 reads

Blogs

The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering

By

(This post starts a three-part series on how AI is changing the way we...

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

By

I was looking over the CHOOSE() function while editing an article at SQL Server...

Read the latest Blogs

Forums

Managed Instance vs Azure Database - is this a good option?

By jasona.work

We're currently in Azure, however as we had a very tight migration timeline when...

MERGE in a nested TRY/CATCH won't roll back

By Pete Bishop

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers