Power BI DAX What If Parameter to make calculations dynamic

  Рет қаралды 1,414

RADACAD

RADACAD

Күн бұрын

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

Пікірлер: 11
@jazzista1967
@jazzista1967 11 сағат бұрын
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 4 сағат бұрын
Glad it was helpful!
@MpT_Head
@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
@RADACAD 4 сағат бұрын
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
@AnshulMarele-gbaa Күн бұрын
👌🏻
@arbazahmad7177
@arbazahmad7177 Күн бұрын
Excellent 🎉.. thanks for sharing
@RADACAD
@RADACAD Күн бұрын
Thanks for watching!
@yekhtiari
@yekhtiari Күн бұрын
Can we change the column's title dynamicly ?
@RADACAD
@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
@yekhtiari Күн бұрын
@RADACAD Thanks for the quick reply. I've been waiting for this feature for so many years.I am losing my hope!
My 3 SECRETS for Power BI Parameters You MUST TRY!
25:58
How to Power BI
Рет қаралды 31 М.
规则,在门里生存,出来~死亡
00:33
落魄的王子
Рет қаралды 25 МЛН
Spongebob ate Patrick 😱 #meme #spongebob #gmod
00:15
Mr. LoLo
Рет қаралды 19 МЛН
💩Поу и Поулина ☠️МОЧАТ 😖Хмурых Тварей?!
00:34
Ной Анимация
Рет қаралды 2 МЛН
Printing Power BI   Analyze in Excel VS Paginated Reports
16:03
Introduction to DAX in Power BI
41:05
Bulldog Analytics
Рет қаралды 385
Power BI Update - September 2024
33:21
Microsoft Power BI
Рет қаралды 32 М.
Visual Calculations in Power BI - DAX Made Easy! [Full Course]
1:30:40
Pragmatic Works
Рет қаралды 41 М.
No More DAX? Power BI’s NEW Feature Explained (File Included)
7:30
MyOnlineTrainingHub
Рет қаралды 125 М.
Power Query Basics of M Scripting in Power BI and Fabric
19:36
ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024)
3:40:48
Pragmatic Works
Рет қаралды 109 М.
Breaking Leptop in Every Possible Way! 💻💔" #shorts
0:52
Light Movies
Рет қаралды 1,5 МЛН
The force of electromagnetic eddy currents
0:31
Nikola Toy
Рет қаралды 16 МЛН
Складной ВТРОЕ смартфон!
0:58
808
Рет қаралды 187 М.
Что лучше ноутбук или ПК в бюджете 100к?
0:34