Power BI DAX What If Parameter to make calculations dynamic

[@Jacoba_0_813]

great tutorial for dynamic calculation. thanks

[@RADACAD]

Glad it was helpful!

[@jazzista1967]

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]

Glad it was helpful!

[@arbazahmad7177]

Excellent 🎉.. thanks for sharing

[@RADACAD]

Thanks for watching!

[@MpT_Head]

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]

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

[@AnshulMarele-gbaa]

👌🏻

[@yekhtiari]

Can we change the column's title dynamicly ?

[@RADACAD]

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

[@yekhtiari]

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