Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
is thier a way to flip (reverse) the contant of a field i.e volumn x has the value 12345 i need it to be displayed 321
Solved! Go to Solution.
Are you reversing and truncating or just reversing? You can reverse text in M by saying
Text.Combine(List.Reverse(Text.ToList("12345")))
Are you reversing and truncating or just reversing? You can reverse text in M by saying
Text.Combine(List.Reverse(Text.ToList("12345")))
Hi..
Didn't find the text.combine function in the dax query..can u please help
Text.Combine is an M function available in Power Query, the ETL tool included in Power BI. DAX is the query language for Power Pivot/SSAS Tabular, the modelling and analytical engine in Power BI.
You can use Text.Combine in the get data portion of Power BI if you choose to edit the query.
Brilliant, missed that Text.ToList function when I scanned through the list of functions. Nice and clean.
Here's an Excel formula I found that you could probably adapt using equivalent DAX functions:
Type this formula:
=IF(LEN(A1)<1,"",MID(A1,LEN(A1),1))&IF(LEN(A1)<2,"",MID(A1,LEN(A1)-1,1))&IF(LEN(A1)<3,"",MID(A1,LEN(A1)-2,1))&IF(LEN(A1)<4,"",MID(A1,LEN(A1)-3,1))&IF(LEN(A1)<5,"",MID(A1,LEN(A1)-4,1))
DAX has LEN and MID formulas. Replace A1 with your column name.
Got the formula from here:
http://www.extendoffice.com/documents/excel/1146-excel-reverse-string-word-order.html#a1
Nothing that I can find here:
https://msdn.microsoft.com/en-us/library/ee634938.aspx
You might be able to get there with some really nasty code that uses LEN and LEFT, etc.
I also looked here:
M Code has a List.Reverse, but you have to get the string into a list format and Text.Split requires a delimiter so not sure how you might accomplish that one in M Code.
Probably a way but I'd have to think on it...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |