Forum Discussion

sharpedogs's avatar
sharpedogs
Icon for Advocate II rankAdvocate II
5 years ago

New Column that returns a single value based on date?

Hi,  I have the below data set with dates as to when a customer filled out a survey. I want to create two new columns that shows me their response based on The First Survey they filled out (earliest...
DAX Calculation
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Here's a slightly more noble version

 

First Response =
var c = [Customer]
var f = minx(filter(Surveys,[Customer]=c),[DateValue])
return minx(filter(Surveys,[DateValue]=f && [Customer]=c),[Response])
 
What do you expect to happen when the user submits multiple surveys on the same day?
  • sharpedogs's avatar
    sharpedogs
    Icon for Advocate II rankAdvocate II
    5 years ago

    A customer (person) is only sent one survey a quarter. So there is no issue with multiple on the same day.