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 PowerBI users,
Im fairly new at PowerBI so I hope someone can help out abit.
I have a dataset that contains the following columns:
Hours
Issue_key
I want to create a new calculated column that sums up all hours that is not logged on a issue_key that starts with IW
In the screenshot the SUM would be 0,25
I figure I need to use the SUMX Filter, but I am unsure how to structure it.
Thanks
Solved! Go to Solution.
Hi @MartinBT,
First create a new column
test = LEFT(Table1[issue key],2)
then create a measure
Measure = SUMX(Table1,IF(Table1[test] <> "IW",(Table1[hours]),0))
Please see the attached snapshot
Thanks,
Himanshu
Hi @MartinBT,
First create a new column
test = LEFT(Table1[issue key],2)
then create a measure
Measure = SUMX(Table1,IF(Table1[test] <> "IW",(Table1[hours]),0))
Please see the attached snapshot
Thanks,
Himanshu
Great solution @himanshu56
Thanks for helping out, it works like a charm. I didnt think of extracting the IW first in a column.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |