Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I need to create a new column by looking up distinct values from "Bid Number" and "Class" and sum up the "bid value" in the new column. Any help is greatly appreciated.
for example: I want to create "Bid value total" column based on unique values where "Bid Number" & "class" are same.
Bid Number Bid value class Bid value total
151 10 a
151 10 a 20
151 10 b
151 5 b 15
152 10 b
152 20 b 30
Solved! Go to Solution.
@n2p2gupta wrote:
I need to create a new column by looking up distinct values from "Bid Number" and "Class" and sum up the "bid value" in the new column. Any help is greatly appreciated.
for example: I want to create "Bid value total" column based on unique values where "Bid Number" & "class" are same.
Bid Number Bid value class Bid value total
151 10 a
151 10 a 20
151 10 b
151 5 b 15
152 10 b
152 20 b 30
You can either create a calculated column
bid value total colum = CALCULATE ( SUM ( yourTable[Bid value] ), FILTER ( yourTable, EARLIER ( yourTable[Bid Number] ) = yourTable[Bid Number] && EARLIER ( yourTable[class] ) = yourTable[class] ) )
Or create a measure and put data in a Table visual.
bid value total measure = CALCULATE ( SUM ( yourTable[Bid value] ), ALLEXCEPT ( yourTable, yourTable[Bid Number], yourTable[class] ) )
@n2p2gupta wrote:
I need to create a new column by looking up distinct values from "Bid Number" and "Class" and sum up the "bid value" in the new column. Any help is greatly appreciated.
for example: I want to create "Bid value total" column based on unique values where "Bid Number" & "class" are same.
Bid Number Bid value class Bid value total
151 10 a
151 10 a 20
151 10 b
151 5 b 15
152 10 b
152 20 b 30
You can either create a calculated column
bid value total colum = CALCULATE ( SUM ( yourTable[Bid value] ), FILTER ( yourTable, EARLIER ( yourTable[Bid Number] ) = yourTable[Bid Number] && EARLIER ( yourTable[class] ) = yourTable[class] ) )
Or create a measure and put data in a Table visual.
bid value total measure = CALCULATE ( SUM ( yourTable[Bid value] ), ALLEXCEPT ( yourTable, yourTable[Bid Number], yourTable[class] ) )
Thanks Eric!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
5 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |