Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I have a table(candidates_table) with candidate id, application id and candidate stage. The table looks as follows:
candidate_id | application_id | Candidate_stage
1 CAND-1 Interview
1 CAND-1 Offer
1 CAND-1 Ready for Hire
2 CAND-2 Interview
2 CAND-2 Offer
I'm trying to create dax code to retrieve the distinct count of candidates that made it to the Candidate Stage "Offer" but didn't make it to the "Ready for Hire" stage (in this case the count would be 1=candidate 2). Any ideas would be appreciated! Thanks!
Solved! Go to Solution.
For fun only, a showcase of powerful Excel worksheet formula; btw, I'm just got hired with decent salary by a big company for my proficiency in Excel.🤣
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
You could create the 2 separate tables for the Offer and Ready for Hire separately :
1-
For fun only, a showcase of powerful Excel worksheet formula; btw, I'm just got hired with decent salary by a big company for my proficiency in Excel.🤣
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |