Forum Discussion

LauraCawdronDav's avatar
LauraCawdronDav
Icon for Helper I rankHelper I
3 years ago
Solved

Two different date columns on one chart

Hi,   I’m not sure this is even possible but thought this would be the best place to ask! I’ve been asked to create a chart which shows months this year along the x axis and value of opportunities ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

LauraCawdronDav , With a common date table with active inactive joins and measures like. Refer examples

 

Expected  = CALCULATE(COUNT(Table[Opportunity Id ]),USERELATIONSHIP(Table[expected close Date],'Date'[Date]) )

Won  = CALCULATE(COUNT(Table[Opportunity Id ]),USERELATIONSHIP(Table[Won Date],'Date'[Date]),not(ISBLANK(Employee[Won Date])))

 

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

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi