Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to populate a cell with the latest date. The issue is that some cells have multiple dates and that's throwing this error: "A table of multiple values was supplied where a single value was expected." Here's my formula:
Solved! Go to Solution.
Try this
SNE = CALCULATE ( MAX ( Event[ActivityDate] ), FILTER ( Event, Event[Account/Opp Id] = Opportunity[Id] ) )
Try this
SNE = CALCULATE ( MAX ( Event[ActivityDate] ), FILTER ( Event, Event[Account/Opp Id] = Opportunity[Id] ) )