Power BI DAX What If Parameter to make calculations dynamic

Поділитися
Вставка
  • Опубліковано 10 жов 2024
  • Power BI has two types of parameters: Power Query and What if parameters. In this video, I will explain a very useful use case of the what-if parameters, and if you haven't ever worked with it, it is a great way to understand what-if parameters are and what you can do with them. The What If parameters are also called informally as DAX parameters.
    find the codes from my blog article here:
    radacad.com/po...

КОМЕНТАРІ • 13

  • @Jacoba_0_813
    @Jacoba_0_813 3 дні тому

    great tutorial for dynamic calculation. thanks

    • @RADACAD
      @RADACAD  2 дні тому

      Glad it was helpful!

  • @jazzista1967
    @jazzista1967 10 днів тому

    Great video Reza specially the dynamic title part. You gave me an idea for a report at the office where I can use the dynamic title. Thanks for posting

    • @RADACAD
      @RADACAD  10 днів тому

      Glad it was helpful!

  • @arbazahmad7177
    @arbazahmad7177 11 днів тому

    Excellent 🎉.. thanks for sharing

    • @RADACAD
      @RADACAD  11 днів тому

      Thanks for watching!

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 11 днів тому

    👌🏻

  • @MpT_Head
    @MpT_Head 11 днів тому

    Can you add additional columns into the generated table for alternative selections? I have seven metrics measured in 'Days' as compliance targets ranging from 3 to 84 days. I would like to be able to propose new values for several of the targets to compare performance with the current established targets. So the 5 day target reduced to 4 days, the 14 day target reduced to 10 days, the 21 day target reduced to 15 days etc. In your scenario I think the equivalent would be to be able to also select weeks, maybe two weeks periods etc. Or would I need to set up several What If parameter tables for each target?

    • @RADACAD
      @RADACAD  10 днів тому

      You can generate a table in DAX using table constructor with as many columns you want, I have a video about table constructor. another way is to use ADDColumns

  • @yekhtiari
    @yekhtiari 11 днів тому

    Can we change the column's title dynamicly ?

    • @RADACAD
      @RADACAD  11 днів тому +1

      Not at the moment, in the future maybe
      You fan put a card visual on top of it and change that dynamically though

    • @yekhtiari
      @yekhtiari 11 днів тому

      @RADACAD Thanks for the quick reply. I've been waiting for this feature for so many years.I am losing my hope!