Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Menu
Search
0
LOGIN

Home
Training
Consulting
Articles & Blog
Videos
Books
Tools
About

Accept cookies to show this video. Cookies Policy
Allow all cookies

Variables – The Whiteboard #05

A variable is a constant in DAX. Is it more clear if we draw it?

Sep 7, 2022

LinkedIn Twitter Facebook Email

Subscribe

Comments

You need to login in order to comment this video.

Login Or register

Subscribe

Notify of

Please login to comment

2 Comments

Inline Feedbacks

View all comments

David Estape

1 year ago

Is it possible to create a global variables in DAX? A variable that can be accessed by several different measures, not only in the local definition of the measure?

I usually need to do som complex calculations based in a virtual table (where a filter context has been applied) as an intermediate step, then create several measures that calculates based in this virtual table.

Since this virtual table is a local variable “by definition”, the Storage Engine is queried multiples times, when it would be optimal to share this virtual table between several related measures.

0

Sergio Murru

1 year ago

Reply to David Estape

No, there are no global variables in DAX language.

1

All
The Whiteboard

17:05

Comparing cumulative metrics for events with different start dates

Apr 23, 2024
26:39

Using EXPAND and COLLAPSE in visual calculations

Apr 9, 2024
25:49

Use scatterplots to find details in Power BI reports

Apr 3, 2024
01:39

Revolutionizing Power BI: Introducing the Ultimate Formula Language

Apr 1, 2024
19:52

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

Mar 27, 2024
15:15

Vpax Obfuscator and DAX Optimizer – Unplugged #57

Mar 21, 2024
00:18

SqlBits 2024 – Day 1

Mar 20, 2024
00:35

Preparation for the training day @SqlBits 2024

Mar 20, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

226.9K subscribers

Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

SQLBI Days – Introduction to DAX – Apr 30
, Chicago
SQLBI Days – Advanced DAX – May 1
, Chicago
SQLBI Days – First Steps in DAX Optimization – May 2
, Chicago
Mastering DAX – May 6
, Seattle
Mastering DAX – May 14
, Hamburg
Mastering DAX – May 22
, Copenhagen
SQLBI Days – Introduction to DAX – May 27
, Amsterdam

YouTube Twitter LinkedIn Facebook Github RSS Feed

Marco Russo Alberto Ferrari Daniele Perilli

2004-2024 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.

Privacy Policy & Cookies Terms & Conditions Contact Us

You are going to send email to

Move Comment