Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have table and need to write formula in Column2 where Column1 values would be lookuped up by date. Any help please?
Solved! Go to Solution.
@Edmundas Maybe:
Column2 =
VAR __Date = [Date]
VAR __Table = FILTER(ALL('Table'),[Date] = __Date)
RETURN
MAXX(__Table,[Column1])
@Edmundas Maybe:
Column2 =
VAR __Date = [Date]
VAR __Table = FILTER(ALL('Table'),[Date] = __Date)
RETURN
MAXX(__Table,[Column1])
Thank you so much, it worked perfectly!