Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need a advice.
I need in PBI create new column where will be result column "F".
Column "F" (Priority) is RATING according to minimum Haulier price (column "D").
But when column "E" (Destination exclusivity) is 100% so column "F" (Priority) is 1.
Thank you
Ondřej
Solved! Go to Solution.
Here is a column expression that shows one way to do it. Just replace Price with your actual table name.
Priority =
VAR vThisCode = 'Price'[Code]
VAR vThisPrice = 'Price'[Haulier price]
VAR vRank =
RANKX (
SUMMARIZE (
FILTER ( 'Price', 'Price'[Code] = vThisCode ),
'Price'[Haulier price]
),
'Price'[Haulier price],
vThisPrice,
ASC
)
RETURN
IF ( 'Price'[Destination exclusivity] = 1, 1, vRank )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Here is a column expression that shows one way to do it. Just replace Price with your actual table name.
Priority =
VAR vThisCode = 'Price'[Code]
VAR vThisPrice = 'Price'[Haulier price]
VAR vRank =
RANKX (
SUMMARIZE (
FILTER ( 'Price', 'Price'[Code] = vThisCode ),
'Price'[Haulier price]
),
'Price'[Haulier price],
vThisPrice,
ASC
)
RETURN
IF ( 'Price'[Destination exclusivity] = 1, 1, vRank )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |