Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I'm trying to count how many candidates were never touched in a Vacancy since they applied. I have 2 date/time columns that can tell me that. One is the Candidate Submitted Date (Candidate_SubmittedDate) and the other is Moved to Date (Candidate_CurrentFolder_SetOn). If they match, then the candidate was never touched.
The way I would do it is like the formula below, but given the fact that these fields contain DATE and TIME they will never match as the system does the 2 processes withing a few seconds apart. Is there a way to compare only the DATES in a Measure? Or I need to go in Power Query and change Type or split columns?
Solved! Go to Solution.
Hi @OvidiuNeacsu,
you can use following formula
_Candidate_Never_Moved =
SUMX (
report,
IF (
[Candidate_SubmittedDate].DATE = [Candidate_CurrentFolder_SetOn].DATE,
1,
0
)
)
Found the issue it's [Candidate_SubmittedDate].[Date]
Thank you very much!
Highly appreciated,
Ovidiu
Hi @OvidiuNeacsu,
you can use following formula
_Candidate_Never_Moved =
SUMX (
report,
IF (
[Candidate_SubmittedDate].DATE = [Candidate_CurrentFolder_SetOn].DATE,
1,
0
)
)
Found the issue it's [Candidate_SubmittedDate].[Date]
Thank you very much!
Highly appreciated,
Ovidiu
Tried to reverse the fields... They are both DATE/TIME, i don't know why the 2nd appears as grey.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |