Issues with filtering by date

[AndrewMarkham86]

Hi all,

I am after some help please.

I have a table visual which is pulling data from a couple of different data tables. I have a list of "application names" and I am trying to filter them by the last time each application was updated. When I filter by last updated, it gives me the same date for every application rather than the last date each specific application was updated. 

I am wondering if this could possibly be something to do with a lack of relationship between the two tables the data is being pulled from, as a new data table was introduced and I can see there is no relationship set up.

Any help would be massively appreciated. 

Thanks. 

[Anonymous]

Hi, @AndrewMarkham86 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AndrewMarkham86]

Now got a new issue, the date now doesn't correspond to the orignal date from the "last updated" coloumn from the original table. 

[AndrewMarkham86]

For anyone else reading, I have managed to solve the issue. I created a new index column in each table, then was able to link the two tables that way, then add the "date updated" column into the table with "application name". This then automatically resolved the date issue. 

[Sahir_Maharaj]

Hello @AndrewMarkham86,

Instead of directly pulling in the "Last Updated" column, can you please try creating a DAX measure that dynamically finds the latest update per application.

Last Updated Date = 
CALCULATE(
    MAX('Update Table'[Update Date]),
    ALLEXCEPT('Update Table', 'Update Table'[Application Name])
)

[AndrewMarkham86]

Would I be able to do this, with the fact the it is pulling the data from two different data tables. It is pulling the "application name" from one table and "updated date" from another? 

Thank you. 

[Akash_Varuna]

Hi @AndrewMarkham86 issue is likely due to the lack of a relationship between your tables could you try these

•  Check Relationships: In Model View, ensure there's a relationship between the tables . If missing, create one with appropriate cardinality.
• Use a Measure: Create a measure to calculate the correct "Last Updated" date:
  LastUpdated = MAX('Table'[UpdateDate])
  
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[AndrewMarkham86]

I have tried to create a relationship between the two tables, however because there is no unique value between the two tables it won't let me. 

Thank you.