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

Are you loading the measure on your sample dataset, or on a larger dataset?

 

 

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