0 votes
1 view
in BI by (10k points)

enter image description here

This is the input table of the data 

and I want the desried output

enter image description here

As shown in the table,How can I do this by using Power Bi

1 Answer

0 votes
by (20.5k points)
edited by

Use the following measures

Value.Is([Column], Int64.Type)

Example, 
IsNumber =Value.Is(Value.FromText([ColumnOfMixedValues]), type number)
Value.Is([Column],type text)

Example, 

IsText =Value.Is(Value.FromText([ColumnOfMixedValues]), type text) 

if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))  

  If you wish to learn more about Power BI? Refer to Power BI Training

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...