Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have another questions about coloones updates on data base table.
On Power Bi the source of data is excel file and in this excel file for example all values of colonne1 have more caractere that when we try to do some Kpi table it's will be long table Colonnes 1 ....Number_name table ...
The asking is i need to create New colonne where the Colonnes 1 values will be formated.
For example Values Colonnes 1
value_1_abcd---------------- > On new Colonne it will be Value1
value_2_abco---------------- > On new Colonne it will be Value2
value_3_abcd---------------- > On new Colonne it will be Value3
value_4_abcd---------------- > On new Colonne it will be Value4
value_5_abcd---------------- > On new Colonne it will be Value5
Can you give one if condition will all this
thanks
Solved! Go to Solution.
It sounds like you need to use the "Split by delimiter" functionality in Power Query:
Let me know how it goes!
/ J
Hi Friend,
thansk for feed back.
I will create new colonne and in this colonne i will make
Values Old colonnne with New format with replacing
value_1_abcd---------------- > BY In the new Colonne will be Value1
so it's will be done like this
New colonne on table
and contain of this colonne will be :
Value 1
Value2....
so it's will be if condition with if ... ( 'old colonnne contain value1', value1)....
Alright so it's a new column like this:
Old column | New Column |
Value_1_ABC | Value1 |
Value_2_ABC | Value2 |
Value_3_ABC | Value3 |
Value_4_ABC | Value4 |
I'm assuming your actual values are different to your examples so it's quite hard to propose an exact solution.
You can use LEFT( [Old_Column] , X )
https://docs.microsoft.com/sv-se/dax/left-function-dax
This takes X number of characters from the left.
You can use SWITCH( [Old_Column] , "Value_1_ABC" , "Value1" , "Value_2_ABC" , "Value2" )
https://docs.microsoft.com/en-us/dax/switch-function-dax
This looks for specific values and switches them if it finds them.
From what you're writing in the end i believe that the switch is right for you.
/ J
Hi,
i have take this solution
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |