Forum Discussion
Dates Between Dates Diff Tables
Anonymous , Check the attached file after signature
Anonymous , not very clear. But refer my blog on the same topic
Hm, I am not trying to find the date difference, but to see whether TRANS_DT is between two dates in a column in a different table.
If so, I am trying to put the GRADE from the row of the Effective Date that is before the TRANS_DT
Basically, can you do an index match formula in Power BI i think is my question...
=INDEX('Job Title'!$H$2:$H$6,MATCH(1,IF('Job Title'!$C$2:$C$6<=Labor!M4,1)))
Anonymous , Refer if this can help. https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Take the idea of how current employees are created
Check this file has a better example - https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
Check how the leave between dates summed up
Or
Can you share sample data and sample output.
https://docs.google.com/spreadsheets/d/1cNTBijTIKX2PRo991UALOsxtyMV3JsxJ0CDF5RJYsjE/edit?usp=sharing
i am not sure how to share an excel file so i created it in google docs... hope you can see it haha.. my goal is to get the GRADE column in the Labor tab through a Power BI formula, if possible
Thank you!
Sarah