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 Team,
Need your help here
I have a table (name: EmpDetails) with two columns as "EmpID" and "Marks"
EmpID | Marks |
100 | 35 |
200 | 45 |
300 | 55 |
400 | 78 |
500 | 25 |
600 | 92 |
Now, I have created a mesuare which returns a value (say the value is 50)
I wanted to create a new column in the table as "Flag" which should compare the Marks available at each EmpID and flag it as "Below avg" or "Above Avg"
EmpID | Marks | Flag |
100 | 35 | Below Avg |
200 | 45 | Below Avg |
300 | 55 | Above Avg |
400 | 78 | Above Avg |
500 | 25 | Below Avg |
600 | 92 | Above Avg |
can you please help me on this.
Regards,
Kamal M.
Solved! Go to Solution.
Hi @Kamalakar ,
If your measure1=50 is already defined then you can use:
Flag = IF(SUM('Table'[Marks])>[Measure1],
"Above avg","Below avg")
Hope it helps.
Thanks, mahenkj2
this helps.
Hi @Kamalakar ,
If your measure1=50 is already defined then you can use:
Flag = IF(SUM('Table'[Marks])>[Measure1],
"Above avg","Below avg")
Hope it helps.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |