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.
This post has closed.
Solved! Go to Solution.
@zalalu
This is power query formula know as M function. It is difficult to detect the error without see your model. In power query, you may refer to Solved: Collation Error - Microsoft Power BI Community
Or try create a calculate column or measure using DAX formula.
Column = if([release_item_id]=blank(), [item_id], [release_item_id])
Measure = if(max([release_item_id])=blank(),max([item_id]),max([release_item_id]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Short of having the database changed to suit your needs, you'll have to stop the query from folding back to the server before this step. You could try adding an index column. You could also replace values in the column, instead of making a new column, like:
= Table.TransformColumns(NameOfPreviousStep, {{"Release_Item_ID", each Table.ReplaceValue(_, null, [Item_ID], Replacer.ReplaceText, {"Release_Item_ID"})}})
--Nate
@zalalu
This is power query formula know as M function. It is difficult to detect the error without see your model. In power query, you may refer to Solved: Collation Error - Microsoft Power BI Community
Or try create a calculate column or measure using DAX formula.
Column = if([release_item_id]=blank(), [item_id], [release_item_id])
Measure = if(max([release_item_id])=blank(),max([item_id]),max([release_item_id]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
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.