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.
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
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 |
---|---|
106 | |
104 | |
78 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |