Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hey everyone im trying to do a report where i need to check if the values from "order1" appears in "ReturnId" is this happens i need to get the value of "PointId" from the row where "order1" is filled and put in where the "ReturnId" is the same (i did the example in Excel of what i expect as the result)
PowerBi file
Is there someway to do this?? Thanks
Solved! Go to Solution.
Hey @Anonymous ,
the following calculated column should do the job:
Wanted PointID =
VAR vRowReturnID = Planilha1[ReturnId]
VAR vResult =
CALCULATE(
MAX( Planilha1[PointId] ),
FILTER(
Planilha1,
Planilha1[order1] = vRowReturnID
)
)
RETURN
IF(
vRowReturnID <> BLANK(),
vResult
)
Hey @Anonymous ,
the following calculated column should do the job:
Wanted PointID =
VAR vRowReturnID = Planilha1[ReturnId]
VAR vResult =
CALCULATE(
MAX( Planilha1[PointId] ),
FILTER(
Planilha1,
Planilha1[order1] = vRowReturnID
)
)
RETURN
IF(
vRowReturnID <> BLANK(),
vResult
)
Perfect!! thanks a lot
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |