I need help a lot. I have one column in my database, which consist of numbers and text:
I want to create new 2 columns which grouped this values by tens and hundreds, e.g. for 122 is in groupe 100 and 120.
What I done by now:
1. I divided the column to keep the number without text
2. I try to create calculated column, like that
[Code — kopia.2] >= 100
&& [Code — kopia.2]<=199,
[Code — kopia.2] >= 200
&& [Code — kopia.2] <= 299,
[Code — kopia.2] >= 300
&& [Code — kopia.2] <= 399,
IF ( [Code — kopia.2] >= 400 && [Code — kopia.2] <= 499,
"400"; "NotExist" )
BUT IT DOESN't WORK.
Can you help me? I need a piece of advice 😞
Solved! Go to Solution.
Hi @ola1996 ,
I would recommend Power Query for data preparation.
Take a look at "Add Column From Examples"
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
first, you are using different delimiters ";" and "," in your statement. it depends on your localization but it should only commas or semicolon
do not hesitate to give a kudo to useful posts and mark solutions as solution
What was the error message? Are the column in correct datatype?
Your expected out is not clear with the statment "e.g. for 122 is in groupe 100 and 120. "
Do you want to group them based on the range?
Refer to this post..(Query Editor- M query)
If this helps, mark it as a solution
Kudos are nice too
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.