• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / VAR

VAR

posted on August 15, 2017

« Back to Glossary Index

Definition

Variables are an extremely useful feature in DAX, but perhaps not a well known one. Variables:
1. Make your formulas more readable
2. You can reuse them through your report
3. Can also be tables
4. Are more efficient

Remarks

–

Tutorial with example

In this tutorial we go through how to write variables in Power BI:

Download example file:

Download our Growth dashboard if you want to see the example live: http://curbal.com/blog/the-ultimate-d…

Deep dive on variables:

Lets do a deep dive into variables shall we? In this video, I am going to cover the following:
1. Naming variables, dos and donts
2. The syntax for calling variables
3. Can a variable refer to a measure?
4. Can a measure refer to an external variable?
5. Can a variable refer to a variable?
6. Can a variable store a table?
6. Can you refer to a column from the table inside the variable?

 

Was this helpful?
[Total: 1   Average: 4/5]
« Back to Index

Reader Interactions

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In