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.
I'm fumbling create a custom column in a table that has already been loaded, this column will be used to relate that table to another, however I am unable to create this custom column.
I need to concatenate all the fields that are in the picture, I do not know what function and how to use, can someone help me?
Solved! Go to Solution.
A Sample:
=[Segment] & Text.From([Count])
If you column is not a string use Text.From([Column]) else just the column name
Thanks for explaining why to use Text.From()
taking advantage, I have a date field that is in the format (dd / mm / yyyy hrs) and need to create a custom column from that field that presents only the yyyy, tried some string functions however nothing.
Date.Year (DateField)
I suspect "The Feature That We Don't Call Power Query" is the best place to do this (which is what folks are doing here) ... but you can also do this via a dax calculated column as well.
something like:
MyCalcColumn = MyTable[MyColumn1] & "-" & MyTable[MyColumn2] & "-" & YEAR(MyTable[MyDateColumn])
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |