Hi.
I am using the following expression to CONCATENATE values from 2 columns
CONCATENATE(
SELECT(MHE_Vehicle_Checklist_Issues_Master[Failed Check],[Record ID]=[_THISROW].[Record ID]),
": ",
SELECT(MHE_Vehicle_Checklist_Issues_Master[Description],[Record ID]=[_THISROW].[Record ID]))
The presentation of the result is (based on 3 values being returned for each column)
[Failed Check] value,[Failed Check] value,[Failed Check] value,
[Description] value, [Description] value, [Description] value.
Is there a way that I can amend the expression so that the presentation comes out as
[Failed Check]: [Description], [Failed Check]: [Description], [Failed Check]: [Description]
Hope this makes sense.
Thank you.
Solved! Go to Solution.
The best approach might be to create a VC in that MHE_Vehicle_Checklist_Issues_Master table
[Failed Check]&": "&[Description]
And list this VCโs values:
SELECT(MHE_Vehicle_Checklist_Issues_Master[VirtualColumn],[Record ID]=[_THISROW].[Record ID])
The best approach might be to create a VC in that MHE_Vehicle_Checklist_Issues_Master table
[Failed Check]&": "&[Description]
And list this VCโs values:
SELECT(MHE_Vehicle_Checklist_Issues_Master[VirtualColumn],[Record ID]=[_THISROW].[Record ID])
Thanks so much @LeventK. I will test your suggestion.
Hi @LeventK.
Your suggestion worked perfectly, thank you again.
Youโre welcome.
Would you benefit from connecting things using references???
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |