Forum Discussion
Converting Spotfire Calculation to Power BI
Hi All,
I have the calculation that was done in spotfire and I need to replicate in Power BI.
Split(Substring([X],1,Len([X])-4),",",-1)
X column contains the values X= 30001234567890.
Regards
Vyshnavi S
HI Anonymous,
AFAIK, Dax expressions seem not suitable to split column operation. I'd like to suggest you do these operations in power query.
You can add a custom column with Text.Start to extract the specific substring from raw values, then you can right-click on this new custom column and choose the 'split column' function.
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Start([X],Text.Length([X])-4))Split a column of text (Power Query) (microsoft.com)
Regards,
Xiaoxin Sheng
1 Reply
HI Anonymous,
AFAIK, Dax expressions seem not suitable to split column operation. I'd like to suggest you do these operations in power query.
You can add a custom column with Text.Start to extract the specific substring from raw values, then you can right-click on this new custom column and choose the 'split column' function.
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Start([X],Text.Length([X])-4))Split a column of text (Power Query) (microsoft.com)
Regards,
Xiaoxin Sheng