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.
Hi All
How to make use of DAX to create 2 new fields from "GL Description" field
For Example :-
AM ACCOUNTANCY FEE
i Hope to convert to :-
GL_Desc2=AM
GL_Desc_Oth=ACCOUNTANCY FEE
My PBI file :-
https://www.dropbox.com/s/ds3bbmxa3dogvvc/PBS_VER050%20GL_LE.pbix?dl=0
Paul
Solved! Go to Solution.
@admin11
Add the following two columns, replace the name of your table and column name with yours in the formula:
GL_Desc2 = LEFT(Table[Column],2)
GL_Desc_Oth = TRIM(MID(Table[Column],3,255))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@admin11
Add the following two columns, replace the name of your table and column name with yours in the formula:
GL_Desc2 = LEFT(Table[Column],2)
GL_Desc_Oth = TRIM(MID(Table[Column],3,255))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |