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/

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks. You mention "You do need to create a separate table for Year". However, I can't find where you are making use of this table in your measures.

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
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/