Do you know if you can use it without a connection, I like using it to do things like build calendar tables, but always have to connect to a power pivot or bi file even though it has nothing to do with building the calendar.
Hi, Can I create measures in DAX Studio, I need to create a bunch of measures and want a swift method. I am converting an excel model to power bi. in excel I've been using calculated fields mostly.
Thank you for sharing this. If I use DAX Studio to create an excel file linked to my power BI dashboard raw data, can a user that I give the excel file to refresh the excel file if they don't have DAX Studio? Sorry if I missed this.
Hello Ruth, I am using 2 table's with one Report each separately and now I want to show another report with both data in one report but when I use dates it not showing correctly... I even tried to import custom calendar and made a relation between them but it's showing some date in blank position...
Curbal , if you have a lot of data columns, and NOT a designated date table and you have not deactivated the time intelligence from power bi in settings, powerbi creates a system date table and own hierarchie per date column. So if you have, like 10 date columns in your model, powerbi creates 10 system tables with hierarchie. I think this will influence the performance. I can send you a printscreen, if you want it. Grtz Frank
I show the students, how to deactivate the intern date hierarchy and time intell and the necessity of a single date table with more then one relation. So the data model is more stable. Also in advanced, i teach them the various aggregation levels, like budget on other level then sales, with connecting tables.
I was looking for a tutorial on using the query builder which does not feature in the video. This video does not help a beginner trying to learn DAX. I suspect this might be why there is a load of downvotes.
It is not that I don’t like it, it just that I use Power BI desktop for the main use cases of DAX studio and for that reason I don’t know all the functionality and I don’t have any tips to give. Hopefully that explains why the tutorial is superficial. /Ruth
@@CurbalEN thanks. And thanks for introducing this topic. I had no idea about this and suddenly I see the advantages of DAX studio - and at the same time I feel trepidation. All this knowledge you have about the precedence rules you just have to learn. Did you say you have produced guidance on these in printable form please?
Do you know if you can use it without a connection, I like using it to do things like build calendar tables, but always have to connect to a power pivot or bi file even though it has nothing to do with building the calendar.
I'm trying to compare data between two different environment. So will the dax studio will fetch the PBI having two different sources?
Thank you for everything, I always look fur Curbal videos whenever I have questions and you are awesome.
Thanks!!! Proud to be your Co-pilot!
/Ruth
Hi,
Can I create measures in DAX Studio, I need to create a bunch of measures and want a swift method. I am converting an excel model to power bi. in excel I've been using calculated fields mostly.
you can directly import the excel data model..
why I can't see advenced icon in DAXStudio (only home icon)?
Thank you for sharing this. If I use DAX Studio to create an excel file linked to my power BI dashboard raw data, can a user that I give the excel file to refresh the excel file if they don't have DAX Studio? Sorry if I missed this.
They need to have dax studio add in excel, otherwise it wont work.
/Ruth
not able to connect Dax studio throwing error connection not establish or timeout..please help
It can be anything, please post in the power bi community and give details about your error.
/Ruth
Hello Ruth, I am using 2 table's with one Report each separately and now I want to show another report with both data in one report but when I use dates it not showing correctly... I even tried to import custom calendar and made a relation between them but it's showing some date in blank position...
Hi 👋
Post your question in the power bi community and give as many details as possible:
m.ua-cam.com/video/oXFOebuvRz0/v-deo.html
/Ruth
Hi Sai ... would you be able to create a new table using calculatetable or summarize. I am quite sure you could combine your tables. Good luck 😀
@@jerrykappa6899 No...but I will try....
I do it using 7 tables and always on the money. Be careful on the syntax between columns and measures.
Super! Is there already a vid for export to sql. I tried to export but nothing is happening...?
Here:
m.ua-cam.com/video/-Gfgnk6R0Qw/v-deo.html
/Ruth
Hi ruth, i also use daxstudio to show the systemtables based on date columns.
Why do you need to see them?
/Ruth
Curbal , if you have a lot of data columns, and NOT a designated date table and you have not deactivated the time intelligence from power bi in settings, powerbi creates a system date table and own hierarchie per date column. So if you have, like 10 date columns in your model, powerbi creates 10 system tables with hierarchie. I think this will influence the performance. I can send you a printscreen, if you want it. Grtz Frank
I was aware of that, but why do you want to see them? What do you do with that?
/Ruth
I show the students, how to deactivate the intern date hierarchy and time intell and the necessity of a single date table with more then one relation. So the data model is more stable. Also in advanced, i teach them the various aggregation levels, like budget on other level then sales, with connecting tables.
Oh, got you! Thanks for sharing :)
/Ruth
I am a huge fan. Learned a lot of things from you. GOOD LUCK FROM BANGLADESH
Thanks! Same to you :)
Thanks for that!
I was looking for a tutorial on using the query builder which does not feature in the video. This video does not help a beginner trying to learn DAX. I suspect this might be why there is a load of downvotes.
Wow! jUST WOW
You said right at the beginning, you don't like using Dax Studio and it kind of showed in this tutorial. But, thank you, as always.
It is not that I don’t like it, it just that I use Power BI desktop for the main use cases of DAX studio and for that reason I don’t know all the functionality and I don’t have any tips to give.
Hopefully that explains why the tutorial is superficial.
/Ruth
Didnt I do that? That was the intention in my mind...
/Ruth
You are talking too lengthy.. Please make it short in the intro section
Helpful but a lot of background noise
I always clean the audio, but sometimes the audio software can not fix it properly.
/Ruth
@@CurbalEN thanks. And thanks for introducing this topic. I had no idea about this and suddenly I see the advantages of DAX studio - and at the same time I feel trepidation. All this knowledge you have about the precedence rules you just have to learn. Did you say you have produced guidance on these in printable form please?
Thanks!!!
My pleasure :)
/Ruth
You look like my mom. Are you Italian?
Close , Spanish :)
/Ruth
Ruth, your body language for explaining Dax Studio seems like you are trying to promote an ex boyfriend for a new job.
😂😂😂
/Ruth
@@CurbalEN But it was good anyway. Thanks