Forum Discussion
Issues with filtering by date
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...
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
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.