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

Hi fahadarshad

 

This worked for me on your test data.  I created the following calculation, which takes advantage of the relationship between Table1 and Table2

 

My Amount = CALCULATE(
			MAX('Table2'[Amount]),
			LASTDATE('Table2'[Date])
			)

 

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

    Hi Phil

     

    I am getting an error saying "a date column containing duplicate dates was specified in the call to the function."

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