Forum Discussion
Measure by Filter Month
Hi, Can anyone help What is the formula of measure if i want to check the active employee based on month ( month will be my filter ) Employee Status Hire Month Terminate Month A A...
Hi, laurent_rio
I am not sure about how your data model looks like, but I think it is better to have Dim-Calendar Table.
Please check the below picture and the sample pbix file's link down below whether it is what you are looking for.
All measures are in the sample pbix file.
https://www.dropbox.com/s/bcehj44udr60kmx/laurent.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.