Creating Date Table Relationship with TopN Table

Power BI Data Model
1

Hi all,

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 #1

image
image705×345 6.97 KB

Image# 2 Data Model

image
image729×601 31.9 KB

PPD Prospects Dashboard.pbit (745.5 KB)

2

I am going a different direction and using different syntax and it worked.

Thanks all.

I am going tou se Goodlys TopN and Others.