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.
I have been acquainting myself with Power BI for about a day now, so you can say I'm a complete novice.
Below are several different companies' price proposals. I want to create a new column to indicate only the "bid amount" if that company was low bidder on the project. The idea is that I could then perform analytics on the revenue of each company. How would I go about doing this?
For example, in the first two rows, I would want a new column that indicates $6078976.36 for "Bidder X" (I drew in the letters) since they were low, and $0 for "Bidder Y," since they lost. Please note that there are several different "Proposals" in this table, I only screenshotted this particular proposal "135" but I'd want to do this for every proposal in my data set.
Essentially, I want to create a new column whose value is based on the minimum bid placed on a given proposal. All other bidders would have a value of 0 for that proposal.
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Please download the demo from the attachment.
Solution 1 based on Power Query.
let currentProposal = [Proposal], currentBid = [Bid Amount]
in
if List.Min(Table.SelectRows(#"Changed Type", each [Proposal] = currentProposal)[Bid Amount]) = currentBid
then currentBid
else 0
Solution 2 based on DAX.
Column = IF ( Table1[Bid Amount] = CALCULATE ( MIN ( Table1[Bid Amount] ), ALLEXCEPT ( Table1, Table1[Proposal] ) ), Table1[Bid Amount], 0 )
Best Regards,
Hi @Anonymous ,
Please download the demo from the attachment.
Solution 1 based on Power Query.
let currentProposal = [Proposal], currentBid = [Bid Amount]
in
if List.Min(Table.SelectRows(#"Changed Type", each [Proposal] = currentProposal)[Bid Amount]) = currentBid
then currentBid
else 0
Solution 2 based on DAX.
Column = IF ( Table1[Bid Amount] = CALCULATE ( MIN ( Table1[Bid Amount] ), ALLEXCEPT ( Table1, Table1[Proposal] ) ), Table1[Bid Amount], 0 )
Best Regards,
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 |