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...
great tutorial for dynamic calculation. thanks
Glad it was helpful!
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
Glad it was helpful!
Excellent 🎉.. thanks for sharing
Thanks for watching!
👌🏻
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?
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
Can we change the column's title dynamicly ?
Not at the moment, in the future maybe
You fan put a card visual on top of it and change that dynamically though
@RADACAD Thanks for the quick reply. I've been waiting for this feature for so many years.I am losing my hope!