Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I'd like to create a label to show a text like this: "150 - Company A", where 150 is a value selected from an input box,(vBusiness) and "Company A" is the name of number 150 company. How can I write this expression?
Is it correct the use of this expression?
='Title:' & ' ' & (vBusiness)& ' ' & ({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])
Any suggestions greatly appreciated.
Regards,
Andrea
Assuming that vBusiness is a variable that contains a numeric value... try this:
='Title: ' & $(vBusiness)& ' ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])
May be like this
='Title:' & ' ' & (vBusiness)& ' ' & Only({$<NumberCompany ={$(=vBusiness)}>}[NameCompany])
Hi,
Use This
='Title: ' & $(vBusiness)& ' - ' & only({$<NumberCompany ={$(vBusiness)}>}[NameCompany])