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

2 years 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

2 years ago

Reply to David Estape

No, there are no global variables in DAX language.

1

All
The Whiteboard

40:08

BLANK in date columns and DAX time intelligence functions

Dec 3, 2024
08:07

Real-World Use Case for DAX Optimizer: Real Estate

Dec 2, 2024
30:25

Compare DAX Optimizer vs ChatGPT vs Copilot for Power BI

Nov 25, 2024
34:26

Computing open orders with visual calculations in DAX

Nov 19, 2024
03:48

Enhance Semantic Model Development with DAX Optimizer CLI (Command Line)

Nov 18, 2024
01:50

Collaborate with your Team and Customers with DAX Optimizer

Nov 11, 2024
33:19

Building bullet charts in Power BI reports

Nov 5, 2024
05:01

Improving Semantic Model Developer Productivity using DAX Optimizer

Nov 4, 2024

Newsletter

By subscribing you are agreeing to our Privacy Policy.

241.7K subscribers

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

What is next

Data Modeling for Power BI – Dec 10
, Amsterdam
Mastering DAX – Feb 11
, Amsterdam
Mastering DAX – Feb 18
, Phoenix
Mastering DAX – Feb 24
, Dallas
Data Modeling for Power BI – Apr 14
, 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