latest status by dax

2 Topics

Latest Status (for Candidate Tracking)
I am working on a candidate tracking report and am struggling with the logic of how to report on the number of candidates in each status (as of a selected date) The data looks like this (simplified) Candidate Date Status 450 1/15/23 A 450 1/15/23 B 450 1/31/23 C 500 12/31/22 A If the selected date on the report is 12/31/22 - then 1 Candidate is in Status A on 1/15/23 1 is in Status A and 1 is in Status B (Max status is used so for the status change on 1/15 "B" should be used Thanks in advance.
Solved
Anonymous
3 years ago Place DAX Commands and Tips
957Views
0likes
4Comments
How to get Latest status from Multiple rows.
Dear Folks, I am pretty new in DAX, and I would like to get the latest status of the position. Below is the screenshot for your reference. Can someone help me to write DAX for the same. I have attached the sample data pbix file as well. https://drive.google.com/file/d/14Iyx355XXoTawhpB1iiuIA_Y2eEBePU1/view?usp=share_link
Solved
ojhassonu
3 years ago Place DAX Commands and Tips
962Views
0likes
2Comments