Getting started with Visual Calcs in Power BI

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 30

  • @workstuff5253
    @workstuff5253 9 месяцев назад +5

    Making full DAX easier to debug would be a great addition to the product.

  • @hi55us2
    @hi55us2 9 месяцев назад +7

    Great video, can't wait for the support to come to more visuals

    • @GuyInACube
      @GuyInACube  9 месяцев назад +1

      Awesome! What is the visual you like this to work with and how would you use it?

    • @hi55us2
      @hi55us2 9 месяцев назад +2

      @@GuyInACube definitely would love to use it on the line and stacked column chart, to have a line graph of a cumulative total and a bar chart of the yearly totals. Already do this with regular Dax measures, but visual calcs would be easier for new projects.

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад

      @@hi55us2 support for the combo charts are coming!

  • @olbu
    @olbu 9 месяцев назад +1

    It seems that it could be calculated on top of the result of a dax query. What is the reason that on-premise SSAS isn't supported?

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад +1

      That is correct. Not yet, at least.

  • @Evaldas65
    @Evaldas65 9 месяцев назад +1

    How would the PREVIOUS function react if a year filter is applied? Say if I looked at 2021, 2022 and 2023 sales, and filtered 2022. In the 2023 column, would 2021, or 2022 be considered as PREVIOUS, if I filtered "Not 2022" in the visual?

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад +2

      That would be 2021, since 2022 is then not on the visual.

    • @oguna2077
      @oguna2077 2 месяца назад

      @@dutchdatadude So it presents an incorrect analysis result?

    • @dutchdatadude
      @dutchdatadude 2 месяца назад

      @@oguna2077 well since visual calculations work on what is on the visual, the previous would refer to whatever was previous on the visual.

  • @noahhadro8213
    @noahhadro8213 9 месяцев назад +1

    When you do versus previous and you are subtracting two measures. What is the engine doing? Is it evaluating that measure two times? Once for the original column and once in the verse previous measure? Would love for visual calc’s to be an optimization as well where the measure is only evaluated one time. I have a 100M fact table so optimization is key and I thought this could be a better way to calculate year over year. When having to show in a table current year, prior year, and year over year.

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад

      it's not re-evaluating the calculation two times, it's only evaluated once against the source.

  • @ExcelWithChris
    @ExcelWithChris 9 месяцев назад

    Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

  • @mishymoo34
    @mishymoo34 9 месяцев назад +6

    As a minimal DAX person, I really like Visual Calcs. It's the best thing developed for on visual to date.

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад +1

      Awesome, glad you like it!

  • @deeswift-z1h
    @deeswift-z1h 9 месяцев назад

    Hi
    It looks out of the context but I wanted to know if is it possible that
    can we 've Month on month %change of count even if we just have one month data and next month data is yet to get updated ?

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад

      I am not sure I understand what you mean. Can you explain?

    • @deeswift-z1h
      @deeswift-z1h 9 месяцев назад

      @@dutchdatadude Hi I 've two month data and now I want month on month % change , while I need that it must show me change in a table view visual without any blank row
      dax

  • @alfredlear4141
    @alfredlear4141 9 месяцев назад +2

    Microsoft just keeps getting progressively better with all their office apps.
    A great new tool for a great bit of software ❤

  • @SachinWarrier-nn2bt
    @SachinWarrier-nn2bt 9 месяцев назад

    I have matrix. In that first column is product. And the rest of the columns are Week1, Week2, Week3 upto week 52. Values in these columns are price of products in each week.
    I need to apply 2 seperate slicer of same thing. That is slicer values are week1, week2...week52.
    If I select week 3 from first slicer then matrix should show values on week3 only. And then I select week 10 from second slicer. Then matrix should show both week 3 and week 10 values only.
    Is there any way to do this.?

  • @blaatfanaat
    @blaatfanaat 9 месяцев назад +1

    You know the behaviour when a Power BI table's totals do not match the sum of the displayed values? When a counted item belongs to multiple row values, if you know what I mean.
    Do visual calculations offer a way around this? Showing the simple "dumb" sum of the displayed values? How?

    • @dutchdatadude
      @dutchdatadude 9 месяцев назад +1

      Not as simple as I want it to be, but yes, using isatlevel and collapse you can do that.

  • @huyhoangnguyen7465
    @huyhoangnguyen7465 9 месяцев назад

    Using Window Function In This Feature to modify Context

  • @xyclos
    @xyclos 9 месяцев назад +1

    These are fantastic news!!!

  • @jeremy8626-r6b
    @jeremy8626-r6b Месяц назад

    Visual Calculations are great. It's almost as good as excel now.

    • @jeremy8626-r6b
      @jeremy8626-r6b Месяц назад

      Just need for them to figure out how to do code level edits and better git version control comparability.

    • @AlainDelon-h9h
      @AlainDelon-h9h 23 дня назад

      🤣

  • @oguna2077
    @oguna2077 2 месяца назад

    OWWW NOOOO!!! a lot of new dax... i wanna cry right now!