Тёмный
No video :(

Learn how the DAX Studio query builder can help you with Power BI 

Guy in a Cube
Подписаться 445 тыс.
Просмотров 59 тыс.
50% 1

You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #DAX #GuyInACube

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

 

15 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 52   
@DPFierce
@DPFierce 3 года назад
Working with SLQ Syntax for so long, I've finding it hard to transition to DAX syntax, but these videos help immensely! Thank-you Patrick!
@davidvayro3464
@davidvayro3464 2 года назад
Structured Language of Queries…?
@carolpruett9741
@carolpruett9741 3 года назад
I can hardly wait to use this at work. Pasting the query with a parameter from the query builder as an .rdl file in the Power BI service will prove useful. Thanks Patrick!
@zylka172
@zylka172 3 года назад
Thanks Patrick! Once my head stopped spinning, I'll try this feature. My list of saved tutorials from you guys is growing every day~
@xylon288
@xylon288 3 года назад
I like your style, than the rest. straight to the point. very fast. its like how I was taught in engineering school.
@sbn4862
@sbn4862 Год назад
Very useful Thank you! One must create such function for DAX Studio. For example -Free Excel table anywhere, you'll write any expression in Excel format then DAX Studio converts it into DAX code ;)))).
@charleswalker2489
@charleswalker2489 2 года назад
God bless you GIAC! This was a life-saver today, thank you
@emmafeng55
@emmafeng55 3 года назад
this is very helpful and I will start looking at it tomorrow!! Thank you Patrick!
@marinamalaty4827
@marinamalaty4827 3 года назад
This is amazing! Thank you Patrick!!
@sue_bayes
@sue_bayes 3 года назад
This is amazing, will help as I've been using the queries in Analyse with Excel
@GuyInACube
@GuyInACube 3 года назад
Nice! Yeah DAX Studio is a great tool!
@vladx3539
@vladx3539 Год назад
I wished I had a Guy in a Cube for all other IT topics I deal with :)
@uatcloud9122
@uatcloud9122 3 года назад
Thanks Patrick! This is a great tutorial for a great tool
@b1k1m1
@b1k1m1 3 года назад
Thanks Patrick!!, WOW this was amazing tutorial. Please keep it up so that we can learn more from you..
@Roger0824
@Roger0824 3 года назад
Nicely edited! Great job.
@andyparkerson
@andyparkerson 3 года назад
Saw the Query Builder on a Saturday morning GIAC livestream, and was in love with it from the start. So glad to learn more about it!
@GuyInACube
@GuyInACube 3 года назад
Awesome! Patrick was really excited about this feature in DAX Studio!
@tenellebernstein9793
@tenellebernstein9793 Год назад
Omg game changer, thank you!!
@ajaaskelainen
@ajaaskelainen 3 года назад
This is something very new that I came accross
@ThorstenLieder
@ThorstenLieder 3 года назад
Hey Patrik, thank you very much, great video. Sorry, one question: is there a way to transform queries also to power bi or direct into (the code) of a visual? Thank you!!
@kennethstephani692
@kennethstephani692 3 года назад
Golden, Patrick, Golden!
@yon_draper
@yon_draper 3 месяца назад
what if I wanted to make a parameter around a date range ? i haven't found anything on the internet successfully helping with setting up date range parameters in dax so that I can use them as parameters in a power bi report builder paginated report connected to a pbi dataset/semantic model
@AnalyticswithNags
@AnalyticswithNags 3 года назад
This is really cool. I hope DAX queries are not as simple as SQL. That's for sure. I hope in this case paginated reports uses the dataset that requires the Dax queries, can be built using query designer in the dataset . Correct me if I am wrong. Since I worked on SSRS I used that option
@Milhouse77BS
@Milhouse77BS 3 года назад
Nice to see the @ parameters!
@GuyInACube
@GuyInACube 3 года назад
YES!
@RKTECH1021
@RKTECH1021 3 года назад
This is Very helpful
@GuyInACube
@GuyInACube 3 года назад
Awesome to hear! Thanks for watching 👊
@DiogoBlunckPanceriValentim
@DiogoBlunckPanceriValentim 3 года назад
Great video. Congrats
@vpwl
@vpwl 3 года назад
Thank you!! Amazing!
@joostwijdeven4957
@joostwijdeven4957 3 года назад
Hi Patrick, like the query builder tutorial, is there any way to handle multiple rows parameters, f.i. (red, yellow, blue) using the query builder. Up to now I had to use a trick provided by Chris Webb to build a list of the parameters?
@earlnoli
@earlnoli 2 года назад
wow Report Builder is still alive.
@piotrbury2493
@piotrbury2493 3 года назад
Dax Studio? My best query builder :-)
@ashishraizada.swas_birds
@ashishraizada.swas_birds 2 года назад
i have to create a maintenance page which changes the dashboard when the data is getting updated. It can reflect to all users and i can bring it down after work is done. How can i do it
@mskovrinskie1
@mskovrinskie1 3 года назад
Is there a way to filter with an OR in the Filters? For example, if I want to filter Fiscal Year Name is FY21 or FY22? The default behavior seems to only allow Fiscal Year name Is FY21.
@dardoschuster6070
@dardoschuster6070 2 года назад
Si hago una consulta en dax como la llevo hacia atras hacia power bi para graficarle ???
@anushyac6575
@anushyac6575 3 года назад
Hi, I have a doubt in powerbi. When we create report, total value is randomly getting calculated at the bottom of the report. But when we export it into CSV or excel file, the total value is not getting added in csv or excel file. Can you help me how to resolve it.
@eljangoolak
@eljangoolak 2 года назад
can the parameter that you enter be a column? how would you enter that?
@youssoufsougueh396
@youssoufsougueh396 3 года назад
Thanks
@blackbull1132
@blackbull1132 3 года назад
How to add multiple starts with filter ???
@PedroCabraldaCamara
@PedroCabraldaCamara 3 года назад
so cool!
@muralikrishna8392
@muralikrishna8392 3 года назад
I want to calculate weekdays between two different dates with multiple condition like, For. Approverd different start and different end Date For hold different start and end date.. All are in same table. I need help.
@JitenderKumar-qy8sp
@JitenderKumar-qy8sp 3 года назад
May I have you internet sales dataset for clearing my queries about some of dax functions. Please confirm
@ameyraj4947
@ameyraj4947 3 года назад
Awesome🎉
@larsschottmadsen
@larsschottmadsen 3 года назад
Thanks Patrick - what video are you referring to at 2:20? I would like to follow up on that.
@QuantumDot2
@QuantumDot2 3 года назад
I think maybe it was this one: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3vcKgN8HxjY.html - “Power BI Case: Too many rows from a DAX Statement”
@larsschottmadsen
@larsschottmadsen 3 года назад
@@QuantumDot2 Thanks Andy
@LaboratoriodeDatosJeje
@LaboratoriodeDatosJeje 3 года назад
You are better
@sarojiniewijesiriwardana7318
@sarojiniewijesiriwardana7318 3 года назад
thanks Patrick and Darren!
@gambu4810
@gambu4810 2 года назад
Quite confusing video. You are too quick sometimes also you move the frames before showing what you clicked
@Astronomynatureandmusic
@Astronomynatureandmusic 9 месяцев назад
Too far over my head... sorry.
Далее
Analyzing a slow report query in DAX Studio
10:33
Просмотров 40 тыс.
Чёрная ДЫРА 🕳️ | WICSUR #shorts
00:49
Просмотров 1,6 млн
NOOOO 😂😂😂
00:14
Просмотров 15 млн
Why you should use DAX Studio with Power BI
7:07
Просмотров 139 тыс.
10X Your Excel Skills with Copilot
12:51
Просмотров 290 тыс.
Debugging a slow Power BI report with Phil Seamark
13:01
Чёрная ДЫРА 🕳️ | WICSUR #shorts
00:49
Просмотров 1,6 млн