Forum Discussion
Retrieve values based on another column value
Hi Anonymous ,
You could edit interaction in Format.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Anonymous , you can not use values there
CALCULATE(Max(Combined[ETA Date]),FILTER(ALL(Combined[DW_InsertedDateTime]),Combined[DW_InsertedDateTime]=max(Combined[DW_InsertedDateTime])))
or
CALCULATE(max(Combined[ETA Date]),FILTER(ALL(Combined[DW_InsertedDateTime]),Combined[DW_InsertedDateTime]=max(Combined[DW_InsertedDateTime])),values(Combined[ETA Date]))
It worked, thank you.
Also, could you tell me how to change it; so, the calculation is not affected by filters?
Regards,
Mario
Hi Anonymous ,
You could edit interaction in Format.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions