Forum Discussion
Solved
New table based on conditional dates
Good afternoon all Hope you are keeping safe I am looking to create a new table based on values in 2 other tables but I am struggling to identify the correct format. I have a table set up as (am...
Create a date table and join it with all three dates. One will active and two will be inactive. Use userelation to use the other dates
Try like
# Candidates Submit = CALCULATE(COUNT(Table[Candidate Name]),USERELATIONSHIP(Table[Candidate Submit Date],'Date'[Date]) ) # Candidates Shortlist = CALCULATE(COUNT(Table[Candidate Name]),USERELATIONSHIP(Table[Candidate Shortlist Date],'Date'[Date]) ) # Candidates Interview = CALCULATE(COUNT(Table[Candidate Name]),USERELATIONSHIP(Table[Candidate Interview Date],'Date'[Date]) )Refer this blog, how it works: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Greg_Deckler
Community Champion
Community ChampionHaving trouble reconciling your expected output to the sample data provided. Is that the full sample data??
Hi Greg_Deckler thank you for the reply
This was not, this was just a mock up I created, due to the nature of the data I am working with I was not able to provide actual data
