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 is a very crude variation.  I know this can be improved with LASTNONBLANKVALUE but i need to re-learn that.

 

Also, "Jan 2th" - really?!

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

i was doing it at 11pm.. after spening 2 hours messing around with it.. give me a break...lol.. I'll try your solution below..

 

thanks