Forum Discussion

pvn's avatar
pvn
Frequent Visitor
3 years ago

DAX Formula

Good Day. I need help in creating a formula like a value based on the selected start and end date. Like this but it is not calculating properly .Thanks in advance Loading Cost SelectedDate = va...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

pvn ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

I think these can help

Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

 

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