Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables
Date | MTD | QTD | YTD
second table is
Selection
MTD
QTD
YTD
slicer hav the values of second table
is there any other way than using if to have sum of MTD column of first table when MTD is selected etc?
Solved! Go to Solution.
Cool,
Try this it will help u, if not let me know.
Note :
If u select multiple option it will move to Others part.
Cool,
Try this it will help u, if not let me know.
Note :
If u select multiple option it will move to Others part.
Cool @Baskar! So you create a var in order to avoid writing the if statement inside switch? Thanks!
Yes u r correct my friend. Var is more powerfull function in DAX.
It will help u in many situation, and good performance too.
🙂
Thanks @Baskar! Can this var used in another measure? eg
SWITCH(Filter_Value,"MTD",SUM('MTD),"QTD",SUM(QTD),"YTD",SUM(YTD),"")
No, Var only used inside the measure , we can't use outside .
Cool
think i found it
its switch...?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |