#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.


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

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:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[alejandra]

Súper útil! Llevo dos semanas adentrándome en el mundo de PBI, iba dando palos de ciego y volviéndome loca! Gracias a tus vídeos estoy ordenando todo en mi mente. Maravilloso! Gracias! (yo también soy súper fan del Cabrales ;))

[abhishekstatus_]

Thanks for sharing the knowledge Ruth ! Looks like the weather is really great over your place ! Have a great weekend ahead!! #DAXFriday

[luisjimenez]

Thanks Curbal, enjoy that landscape!!!!

[thomasivarsson]

Mycket nyttig information Ruth. Ha det fortsatt bra i Jämtland. Sverige har snott landskapet av Norge en gång i tiden.

[mariaen]

Thank you so much! This is enlightening :)

[dannyhometown]

Happy Friday Ruth, fantastic sharing. It really makes sense. I am currently read the book of Dax patterns. And start to taste some deeper of the DAX. Great great thanks for your sharing again. Enjoy your weekend. I am looking forward normal outdoor live. :)

[joseagundis]

Súper útil, gracias Ruth y bonito escenario. Saludos

[didierterrien]

Hello Ruth and thanks for the video,
I didn't know about the glossary’s availability in a report. That’s fantastic! I will create the json to add it to my external tools.

[CTaLieN]

The thing with "EARLIER". I didn't quite understand the numbers you got. How did it calculate it that way? Can anybody help?

[城堡观察者]

Great job! Thanks a lot for your contribution.

[Bharath_PBI]

Thank you for the content Ruth, Appreciate it 👍.

The "other" functions I believe they're called as modifiers (filter modifiers- userelationship, crossfilter, keep filters etc. ) but then keepfilters is also modifier but also can consider as table function

Also, I like the content library report, but should have been place (in video) for a special function which returns both scalar and table depending on the context - the "values ()" .

Probably another DAX Friday. 😊 Happy weekend.

[zzzzzzzzzzzzzzzz]

Thank you, this made sense. Thank you so much. Question, is it possible to use table formula by themselves in excel?

[rajarshisingh]

You said a measure always returns a value, what about the function 'VALUES'? If we write a measure, abc=VALUES(Total Sales) and put this measure in a table visual which contains 2 columns, customernames and Total Sales. It will throw an error as here that function is returning a list. How to know this??

[EricaDyson]

Hi Ruth.. I'm not getting alerts when you produce a new video. I used to. Any ideas why?

[kahhengyeong]

Cool, always good to be back to basic details and learnt something! Didn't realize intellisense was programmed to disallow values output on table measures and vice versa. Guess intellisense is something we can't do without, otherwise troubleshooting would have been a disasterous task.

[DanielWeikert]

Hi Ruth I got a question.
When I use a direct query in Power BI the datamodel structure (e.g. the relationships between tables) are not created. I only get the individual tables. Whe I use import mode I get the complete datamodel including all relationships between tables. Source is Azure SQL. Is this a limitation? Thanks

[BhaveshKumar-dzhq]

why do u laugh without any reason its irritating, btw thanx