DAX studio tutorial: What should I use it for, tool overview

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 48

  • @williamarthur4801
    @williamarthur4801 2 роки тому

    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.

  • @shivaranjinibhat-sc2893
    @shivaranjinibhat-sc2893 2 роки тому

    I'm trying to compare data between two different environment. So will the dax studio will fetch the PBI having two different sources?

  • @UndeadEarth1
    @UndeadEarth1 5 років тому +4

    Thank you for everything, I always look fur Curbal videos whenever I have questions and you are awesome.

    • @CurbalEN
      @CurbalEN  5 років тому

      Thanks!!! Proud to be your Co-pilot!
      /Ruth

  • @hasnainhaider8191
    @hasnainhaider8191 4 роки тому

    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.

    • @thesunnynight
      @thesunnynight 4 роки тому

      you can directly import the excel data model..

  • @Lixia123
    @Lixia123 4 роки тому

    why I can't see advenced icon in DAXStudio (only home icon)?

  • @cv6593
    @cv6593 4 роки тому

    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.

    • @CurbalEN
      @CurbalEN  4 роки тому +1

      They need to have dax studio add in excel, otherwise it wont work.
      /Ruth

  • @madhumitamajhi4965
    @madhumitamajhi4965 5 років тому

    not able to connect Dax studio throwing error connection not establish or timeout..please help

    • @CurbalEN
      @CurbalEN  5 років тому

      It can be anything, please post in the power bi community and give details about your error.
      /Ruth

  • @saiphanindra4081
    @saiphanindra4081 5 років тому

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

    • @CurbalEN
      @CurbalEN  5 років тому +1

      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

    • @jerrykappa6899
      @jerrykappa6899 5 років тому +1

      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 😀

    • @saiphanindra4081
      @saiphanindra4081 5 років тому

      @@jerrykappa6899 No...but I will try....

    • @jerrykappa6899
      @jerrykappa6899 5 років тому +1

      I do it using 7 tables and always on the money. Be careful on the syntax between columns and measures.

  • @dhirajr3376
    @dhirajr3376 5 років тому

    Super! Is there already a vid for export to sql. I tried to export but nothing is happening...?

    • @CurbalEN
      @CurbalEN  5 років тому

      Here:
      m.ua-cam.com/video/-Gfgnk6R0Qw/v-deo.html
      /Ruth

  • @frankgovers8420
    @frankgovers8420 5 років тому

    Hi ruth, i also use daxstudio to show the systemtables based on date columns.

    • @CurbalEN
      @CurbalEN  5 років тому

      Why do you need to see them?
      /Ruth

    • @frankgovers8420
      @frankgovers8420 5 років тому

      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

    • @CurbalEN
      @CurbalEN  5 років тому +1

      I was aware of that, but why do you want to see them? What do you do with that?
      /Ruth

    • @frankgovers8420
      @frankgovers8420 5 років тому +1

      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.

    • @CurbalEN
      @CurbalEN  5 років тому

      Oh, got you! Thanks for sharing :)
      /Ruth

  • @SaddamDipok
    @SaddamDipok 4 роки тому

    I am a huge fan. Learned a lot of things from you. GOOD LUCK FROM BANGLADESH

    • @CurbalEN
      @CurbalEN  4 роки тому

      Thanks! Same to you :)

  • @demaxsuelmarques6382
    @demaxsuelmarques6382 3 роки тому

    Thanks for that!

  • @MrRecombinant
    @MrRecombinant 3 роки тому

    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.

  • @osamaasif9601
    @osamaasif9601 5 років тому +1

    Wow! jUST WOW

  • @SaniGarba
    @SaniGarba 5 років тому +2

    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.

    • @CurbalEN
      @CurbalEN  5 років тому

      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
      @CurbalEN  5 років тому

      Didnt I do that? That was the intention in my mind...
      /Ruth

  • @chamug9086
    @chamug9086 3 роки тому

    You are talking too lengthy.. Please make it short in the intro section

  • @elliottharris4526
    @elliottharris4526 5 років тому

    Helpful but a lot of background noise

    • @CurbalEN
      @CurbalEN  5 років тому

      I always clean the audio, but sometimes the audio software can not fix it properly.
      /Ruth

    • @elliottharris4526
      @elliottharris4526 5 років тому

      @@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?

  • @elrevesyelderecho
    @elrevesyelderecho 5 років тому

    Thanks!!!

    • @CurbalEN
      @CurbalEN  5 років тому

      My pleasure :)
      /Ruth

  • @machinelearningmeetsmma3176
    @machinelearningmeetsmma3176 5 років тому

    You look like my mom. Are you Italian?

    • @CurbalEN
      @CurbalEN  5 років тому

      Close , Spanish :)
      /Ruth

  • @jasonwoodward5501
    @jasonwoodward5501 4 роки тому +1

    Ruth, your body language for explaining Dax Studio seems like you are trying to promote an ex boyfriend for a new job.