#6 DAX Fridays! 101: Scalar vs table vs other functions - Explaining common DAX errors.
Why do you get errors when you use some DAX functions as a measure or table or calculated column?
In today's video, we will explain the difference between scalar vs table vs other functions and explain the following errors:
1. Error when a table is expected but a value is returned
2. The expression specified in the query is not a valid table expression.
3.The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value or
4. EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
Link to the pbix file: https://community.powerbi.com/t5/Data-Stories-Gallery/All-DAX-functions-and-corresponding-DAX-Fridays-tutorials/td-p/774426
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Видео #6 DAX Fridays! 101: Scalar vs table vs other functions - Explaining common DAX errors. канала Curbal
In today's video, we will explain the difference between scalar vs table vs other functions and explain the following errors:
1. Error when a table is expected but a value is returned
2. The expression specified in the query is not a valid table expression.
3.The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value or
4. EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
Link to the pbix file: https://community.powerbi.com/t5/Data-Stories-Gallery/All-DAX-functions-and-corresponding-DAX-Fridays-tutorials/td-p/774426
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Видео #6 DAX Fridays! 101: Scalar vs table vs other functions - Explaining common DAX errors. канала Curbal
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
#2 DAX Fridays! 101: Introduction to filter and row contextPower BI DAX Back to Basics Scalar Vs Tabular FunctionsDAX Fridays! #10: RANK/ TOPN with slicerDAX Fridays Battle #188: FILTER vs CALCULATETABLE - Avoid using FILTER as a filter argumentPower BI Visual Guide #9 - Scatter Chart Pt2 - Creating a Risk Matrix Using a Scatter ChartDAX Fridays! #78: When should I use FILTER() with CALCULATE?DAX Fridays #186: CALCULATE vs CALCULATETABLEDAX Fridays! #5: CALCULATE (Part 1)Can What If parameters help in Power BI reports?Bidirectional relationships and ambiguityValues Function DAXFilter your data on last 30/60/90 days using this trick! // Beginners Guide to Power BI in 2021It's time to free your Power BI data model! We freed up 83%!?!Dynamically Subsetting Table Visuals In Power BIDAX Fridays #193: Why is DAX so difficult to learn?Why Power BI loves a Star SchemaHow to create STUNNING multicards in Power BI with a little bit of DAXCALCULATE Function in DAX