Forum Discussion
Pooji
5 years agoRegular Visitor
Switch Statement in Custom column
Hi, I am having the below column as DAX measure. Can anyone help me in writing the same statement while creating Custom Column. Count of Comapnies = SWITCH( 'Data - Unpivot'[Fund - Copy], "Omega I...
amitchandak
Super User
5 years agoPooji , if this a measure then what you given can work as measure
'Data - Unpivot'[Fund - Copy]
If the above is column for measure you need
max('Data - Unpivot'[Fund - Copy]) or selectedvalue('Data - Unpivot'[Fund - Copy])
else the above should work as column too
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.