The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I want a dropdown list which combines tow columns "FROM_CURRENCY" (CAD, USD...) and "To_CURRENCY" (CAD, USD...)in Sql server. EX: CAD -> USD and USD -> CAD are the same and I write them as CADUSD. I also want them not to be repetitive.
Can someone help me with that?
Thanks
Solved! Go to Solution.
@Anonymous ,
Add a custom column in Query Editor.
Text.Combine(List.Sort({[FROM_CURRENCY],[To_CURRENCY]}))
@Anonymous ,
Add a custom column in Query Editor.
Text.Combine(List.Sort({[FROM_CURRENCY],[To_CURRENCY]}))
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |