Forum Discussion

fahadarshad's avatar
fahadarshad
Icon for Helper I rankHelper I
9 years ago
Solved

Finding amount based on latest date in 2nd table

Hello everyone,   I am new to Power BI and this is my first post on this community.   Here is my Q.   I have two tables   Table1      Table 2      ID Result    ID Amount Date ...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

This doesnt throw an error.

 

My Amount = CALCULATE(
			MAX('Table2'[Amount - Quote]),
			filter('Table2',
				'Table2'[Created On]=MAX('Table2'[Created On])
				)
			)

 

Just checking if it is right

fahadarshad's avatar
fahadarshad
Icon for Helper I rankHelper I
9 years ago

it doesn't throw an error, but doesnt throw any values out either.