I created a separate tables to for unique values and to do some TopN calculations but when I tried to filter by dates, it doesn’t recognize the table. In this example, I created a table called Parent Account TopN which has a one to many relationship with the fact table called Prospects. The date table has one to many relationship with the Prospects table.
In image#1, I tried to view the Top 10 accounts by date and the relationship is not working. This table doesn’t have a date column so how would I go about creating a relationship so that I can filter by dates. I have attached the WIP.
Image# 2 Data Model
PPD Prospects Dashboard.pbit (745.5 KB)