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.
Hi,
Is there any way to get the default value to show from a set of values?
I am using Switch statemet, but it's not fetching me the exact result I am looking for.Kindly let me know if any more information
is required for anlysis.
Thanks,
Ravi
Hi @Anonymous,
>>I am using Switch statemet, but it's not fetching me the exact result I am looking for.Kindly let me know if any more information is required for anlysis.
Switch function contains the default value, you can write the default value at the end of the formula.
For example:
Measure: Swith Statement = SWITCH(MAX(source[Value]),1,"first",2,"second","default") Calculate column: Swith Statement = SWITCH(source[Value],1,"first",2,"second","default")
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for your update, Please find the below link for the actual issue that I am facing, hope this helps you for the understanding.
https://community.powerbi.com/t5/Desktop/Help-With-Formula-to-get-default-values/td-p/143600
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |