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
fahadarshad's avatar
fahadarshad
Icon for Helper I rankHelper I
9 years ago

Hi Phil

 

It is on a larger dataset.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi fahadarshad

 

Any chance you can share a bigger sample so I can try and replicate?

    • 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.