First sale type from list of sales

[ozpeacenik]

I have three tables in my Dataset

Dates (Calendar)

Templates (Customer Records)

Gifts(Sales)

I have created a calculated column in the Templates table to pick up the first gift type, based on the gift date.  It is returning the same result for every record.  There should be two different results in a ratio of approx 1:9.  The result being returned is the lower count.

The column I am using is:
First Gift Type = maxx(
                            topn(1,
                                  summarize('Gifts',Dates[Date],'Gifts'[Gift Type]),
                                 Calculate(min(Dates[Date])),asc),
                                     'Gifts'[Gift Type] )

Relationships are as follows.

Thanks for any help 

[anandav]

@ozpeacenik,

You need to explain your problem with some sample data for the tables and expected results.

Check whether the below artcile could help:

https://whatthetechisthat.wordpress.com/2018/04/09/selecting-the-first-record-with-same-values-in-an...

[ozpeacenik]

First Gift Type is showing what I want to see, but I am getting the same result for every row in my dataset.

[anandav]

@ozpeacenik,

Try creating a new table from your First Gift type table using Summarize function.

[ozpeacenik]

Thanks Anandav, I will give that a try.