DAX to get the amount based on startdate and enddate

[Anonymous]

Can someone please help with DAX!

I need to match the start and end date and take the corresponding amount.

For example ,

12/29 =12/29 and the corresponding amount is 26700

Thanks

[amitchandak]

@Anonymous , refer if this approach can help

A very simple formula can be with independent date table

CALCULATE(
SUM('Table'[Amount]),
'Table'[StartDate] >= SELECTEDVALUE('Date'[Date]) &&
'Table'[EndDate] <= SELECTEDVALUE('Date'[Date])
)

But refer better ways

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970