Forum Discussion

Helper 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
9 years ago
Hi fahadarshad

Please see if this PBIX file works for you

https://wgtnpowerbi-my.sharepoint.com/personal/phil_wgtnpowerbi_onmicrosoft_com/_layouts/15/guestaccess.aspx?docid=015464d806cc346608a271e2e107a2881&authkey=AdZno2vYpEV1eQXsZ2JI51s

fahadarshad

Helper 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

Microsoft Employee

9 years ago

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

fahadarshad
Helper I
9 years ago
Hi Phil

It is on a larger dataset.
- Phil_Seamark
  Microsoft Employee
  9 years ago
  Hi fahadarshad
  
  Any chance you can share a bigger sample so I can try and replicate?
  - fahadarshad
    Helper I
    9 years ago
    I can share with you the entire dataset. Here you go
    
    https://www.dropbox.com/s/kxhsssa9wp0tpyt/Book1.xlsx?dl=0

Forum Discussion

Finding amount based on latest date in 2nd table

Related content

Finding Final amount Current Month ?

Find Latest duplicate

Finding the first record in the latest group

Find Latest date

Power Query Add rows of zero amount