Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.   Regar...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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