Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a table with percentages, and I want to add another table with only five values:
>5%
2<x<5 %
(-2)<x< 2 %
(-5)<x<(-2) %
<(-5)%
How can I do this in Power BI Desktop?
(One of the columns the percentages are based on is from another table.
I tried something like this:
Thanks,
Sigrid
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
It is for creating a new column.
Category CC =
SUMMARIZE (
FILTER (
Category,
Category[Min] < Data[Vektdiff]
&& Category[Max] >= Data[Vektdiff]
),
Category[Category]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
It is for creating a new column.
Category CC =
SUMMARIZE (
FILTER (
Category,
Category[Min] < Data[Vektdiff]
&& Category[Max] >= Data[Vektdiff]
),
Category[Category]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Wow, that was perfect!! Thank you so much! You totally made my morning! =D
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |