Тёмный

MEASURES vs CALCULATED COLUMNS in DAX 

Nestor Adrianzen
Подписаться 22 тыс.
Просмотров 10 тыс.
50% 1

MEASURES vs CALCULATED COLUMNS in DAX/
In this lesson, we will learn the key concepts of measures y calculated columns in DAX.
___________
Highly recommended Power BI books (Affiliate links):
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
___________
Please navigate through the content below:
0:29 Content
1:09 Measures
2:20 Calculated columns
3:51 Measure & calculated column in PBI Desktop
4:46 Measure or calculated column?
6:28 Practical cases
Content link: drive.google.com/file/d/1ngaN...
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/vizxlization
If you don't want to miss anything, subscribe to our newsletter: vizxlization.com/welcome-to-v...
Please follow us on:
Web: www.vizxlization.com/
LinkedIn: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Twitter: / vizxlization
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#vizxlization #Measures #CalculatedColumn #DAX

Опубликовано:

 

29 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 26   
@ebenholz86
@ebenholz86 3 года назад
Thanks! I love that you provided links to the data
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad it was helpful! Keep up the great work, Lesley!
@joelkaragacha1288
@joelkaragacha1288 3 года назад
Genius step by step!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Joel, Glad you found the content helpful. Keep it up!👍
@eduardomunoz2764
@eduardomunoz2764 3 года назад
Excelente como siempre!.. Saludos Néstor
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad it helped, Eduardo!
@hermerbalan82
@hermerbalan82 3 года назад
Thanks a Lot !
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad it helped!
@kanumarlapudikrishnakanth8119
@kanumarlapudikrishnakanth8119 3 года назад
Beautiful Explanation
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad you found it helpful. 👍
@thanomnoimoh9299
@thanomnoimoh9299 3 года назад
Great pbi clip !! Go on
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Thanom, thanks for stopping by. Glad this was helpful.
@bibekanandabhattacharjee952
@bibekanandabhattacharjee952 2 года назад
Good one but I think I need to practice more and more to understand it thoroughly. Thank you @Nestor Adrianzen .
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Welcome to the DAX world, Bibekananda!
@danjarupath
@danjarupath 3 года назад
Love your vdo Make it more my man
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad you found it helpful. Keep it up!
@danjarupath
@danjarupath 3 года назад
Cool
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Excellent!
@jrazafindrabe5229
@jrazafindrabe5229 3 года назад
BOOM !!!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Keep up the good work, J Raz!
@mohdmuzammil3059
@mohdmuzammil3059 3 года назад
1st like 👍
@NestorAdrianzen
@NestorAdrianzen 3 года назад
That's great! Thanks!
@raghun2636
@raghun2636 3 года назад
what is current row???everyone keeps saying this but did not see a proper explaination
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Raghu N, Did you mean Row Context? If so, it's one of the contexts in DAX. Every time we create calculated columns and use iterating functions in DAX like SUMX, there is row context.
@sravankumar1767
@sravankumar1767 3 года назад
I have one doubt can you explain week measures like, Total Amount week to date, Total Amount for last week, Total Amount for same week last year, Period Measures Like Total amount Period to date &&& How to create Date [twomonthperiod] column date table can you please explain briefly...
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Sravan Kumar, For time intelligence calculations, you might want to use the DATEADD function: e.g., DATEADD (Dates[Date], -7, DAY). If you haven't done so, you might want check the following tutorial out for more details: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-32wDjtPBxQY.html
Далее
How to Use the ALL DAX Function in Power BI
25:37
Просмотров 18 тыс.
How to Use VARIABLES in Dax Formulas in Power BI
17:13
#kikakim
00:31
Просмотров 8 млн
DIY rocking horse for your kid #diy #parenting
00:57
Я КУПИЛ САМЫЙ МОЩНЫЙ МОТОЦИКЛ!
59:15
ТРОЛЛИНГ СКАМЕРА СТАНДОФФ 2
00:59
How to Use the CALCULATE Function in Power BI
19:31
Просмотров 58 тыс.
Measures vs. calculated columns in DAX and Power BI
6:00
How to Pivot and Unpivot Columns in Power BI
9:47
Просмотров 18 тыс.
DAX Basics in Power BI Desktop [Part 1]
18:42
Просмотров 94 тыс.
How to Create RELATIONSHIPS in Power BI
19:17
Просмотров 55 тыс.
#kikakim
00:31
Просмотров 8 млн