Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |