Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX: filter a date column based on specific dates from another Table

Hi all, I am going nuts trying to find the solution to this problem. Hope the community might give a helping hand. I have the following tables in my model: (1) Table (Employees) which contains...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    Anonymous 

     

    This is in reference to the additional table you had mentioned in your orignal post:

     

    (3) Table (MthYrTXT) which has 2 columns, namely date and LastDayDate

     

    I have not used it in my calculation. These additional columns (Year, Month, QTR) can be used for filtering the visuals. For calculation, we just need Date column.

     

    Hope this answers your query.

     

    Regards,
    Vivek

    If it helps, please mark it as a solution

    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Please refer to my article on the same line: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin