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.
Hello, I have a couple generic questions regarding adding columns to my data. In my source table I have 2 columns for the date and time. I need to represent that as 1 column in reports so in my edit queries I created a column as
newdatetime = Text.From([log_date]) & " " & Text.From([time])
This trippled the size of my model and I understand it to be due to a combined field like this having less compressability. Is it not possible to have this as a computed value that is not persisted in the model?
And maybe related to this, I was trying to extract a portion of several columns (and do some math etc) as a formula like below. My example is simplified, so in reality column split isn't an answer. In the add custom column of edit queries this produces an error (Expression.Error: The name 'LEFT' wasn't recognized) even though it says the syntax is fine. In the modeling screens new column it does not produce an error. Are they using different languages or syntaxes?
newcol = LEFT([original_col],3)
Also the new columns added in modeling don't appear in the edit queries, which makes me wonder if I'd added my concatenated date & time field there if it would not have physically been stored. I find all this a bit confusing and wonder which place I should be adding custom columns.
Solved! Go to Solution.
@Anonymous
In Edit Query (Query Editor) you are using Power Query (M). In other sections in Power BI you are using DAX.
@Anonymous
In Edit Query (Query Editor) you are using Power Query (M). In other sections in Power BI you are using DAX.
Thanks very much. Basic question but that helps!
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 |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |