Forum Discussion
fahadarshad
Helper I
Helper IFinding 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 ...
fahadarshadHelper I
Helper II can share with you the entire dataset. Here you go
https://www.dropbox.com/s/kxhsssa9wp0tpyt/Book1.xlsx?dl=0
Phil_Seamark
Microsoft Employee
Microsoft EmployeeThis 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
- Phil_Seamark
- fahadarshad
Thank you!!!!!
- fahadarshad
it doesn't throw an error, but doesnt throw any values out either.