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 Guys,
I have an issue I need to solve and it is like this:
Level name | Minimum Value | Maximum Value |
Level 1 | 0 | 999.99 |
Level 2 | 1000 | 2599.99 |
Level 3 | 2600 | 4999.99 |
Level 4 | 5000 | 999999.99 |
I need some way to add third column to second table, and that column represents Level name, based on value of collected points, and that value belongs to scale in first table. I know how to make it in SQL, I know there is, always, function IF, but first table is dynamic (tomorrow there can be 6 levels), it changes per month...
Thanks in advance....
Solved! Go to Solution.
Hi @srdjanmish
try a new measure
Measure =
calculate(
FIRSTNONBLANK('Table'[Level name];1);FILTER(ALL('Table');[YOURVALUE]>='Table'[Minimum Value] && [YOURVALUE]<='Table'[Maximum Value]
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @srdjanmish
srdjanmish's suggestion should be helpful.
Hi,
I am in middle of transfering and modeling data for this example, and, as soon as I get to test it, I vil give feedback. I think this is OK, and it will work..
Hi @srdjanmish
try a new measure
Measure =
calculate(
FIRSTNONBLANK('Table'[Level name];1);FILTER(ALL('Table');[YOURVALUE]>='Table'[Minimum Value] && [YOURVALUE]<='Table'[Maximum Value]
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |