#6 DAX Fridays! 101: Scalar vs table vs other functions - Explaining common DAX errors.
Vložit
- čas přidán 5. 07. 2024
- 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: community.powerbi.com/t5/Data...
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: 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:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: 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:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Thanks for sharing the knowledge Ruth ! Looks like the weather is really great over your place ! Have a great weekend ahead!! #DAXFriday
Great job! Thanks a lot for your contribution.
Thanks Curbal, enjoy that landscape!!!!
Will do! ⛰
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 ;))
Me das dos alegrias ;)
Thank you so much! This is enlightening :)
Nice view! Thank you!
Súper útil, gracias Ruth y bonito escenario. Saludos
Gracias!
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.
Modifiers! I like that, thanks for sharing :)
Happy Friday!
Mycket nyttig information Ruth. Ha det fortsatt bra i Jämtland. Sverige har snott landskapet av Norge en gång i tiden.
Ska göra o njut av helgen också!
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. :)
We have been lucky in sweden with almost no restrictions! Happy Friday Danny!
@@CurbalEN That's awesome, I am here having a stage 4 lockdown in Melbourne. Enjoy my life working from home. Stay safe and take care, Ruth. :P
You too!
Thanks it is helpful..
Thank you, this made sense. Thank you so much. Question, is it possible to use table formula by themselves in excel?
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.
That would be cool, thanks!
Need to update the glossary too with the new functions :)
Could be great also to add a search text visual to be able to seach into the description :)
Soo true! The file is available for download in the data gallery although I am thinking that I havent load up the latest version 🥴
Great 👍
The thing with "EARLIER". I didn't quite understand the numbers you got. How did it calculate it that way? Can anybody help?
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
Hi, probably the Direct query is only reading the meta data without foreign key references, I tried checking whether automatic detection of relationship is turned on. (But still I see it's only querying metadata and nothing else, might have to create model and set up relationships, which I am also doing the same)
I thought the same ( turning on automatic detection) if it is not that, then I dont know
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.
Yes, drove me nuts as a beginner but appreciate it now that I know why ;)
Top...
🥳🥳
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??
You can either read the docs for the function or try and have DAX tell you if it works or not
Hi Ruth.. I'm not getting alerts when you produce a new video. I used to. Any ideas why?
Try this troubleshooter if you are not getting notifications:
support.google.com/youtube/troubleshooter/9334012
why do u laugh without any reason its irritating, btw thanx
I laugh all the time, I am a happy person 😊.
@@CurbalEN sorry if I hurt you (i appreciate ur content ), just wanted to get that out
Don’t worry, you didn’t. I just wanted to let you know that I laugh a lot, so you are ready for the next videos :)
Have a nice weekend!