DAX Formula

Question

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 advanceLoading Cost SelectedDate = var _start= if(MIN('Date'[Date])&gt;=SELECTEDVALUE(BudgetAnnualCost[StartDate]),MIN('Date'[Date]),SELECTEDVALUE(BudgetAnnualCost[StartDate]))var _end = if(MAX('Date'[Date])&lt;=SELECTEDVALUE(BudgetAnnualCost[EndDate]),MAX('Date'[Date]),SELECTEDVALUE(BudgetAnnualCost[EndDate]))var _diff = if(_start&lt;_end,DATEDIFF(_start,_end,DAY)+1,0)Var CST = _diff*SELECTEDVALUE(Project[Daily Loading])Return CST

amitchandak · Answer

pvn , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
&nbsp;
I think these can help
Between Dates - Dates between Measure wayPower BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMhttps://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
&nbsp;
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

pvn · Answer

Hi&nbsp;amitchandak&nbsp; i have one table containing star and end date:&nbsp;&nbsp;other having value:so i need to calculate this value on the basis of that start and end date.thank you&nbsp;

tamerj1 · Answer

Hi&nbsp;pvn&nbsp;How does your visual look like? Is there a relationship between the two tables?

Forum Discussion

DAX Formula

3 Replies

Related content

DAX Formula Help

DAX Formula

DAX Formula

Dax Formula correction help

DAX Formula