Lastday = CALCULATE(DISTINCTCOUNT(survey_reports[responseId]), LASTDATE(date1[Date].[Date]))
Lastday = CALCULATE(DISTINCTCOUNT(survey_reports[responseId]), LASTDATE(survey_reports[date]))
if I am using the date from the date table its showing blank...... need to fix this **bleep**
tnx in advance
Do you have a screenshot showing the error (and the visuals)
Proud to be a Datanaut!
blank is the visual
Lastday = CALCULATE(DISTINCTCOUNT(survey_reports[responseId]),LASTDATE(date1[Date]))
The LASTDATE function is probably returning the very last day in your Date table - which probably goes off into the future. I'm wondering if you actually need the date of the most recent transaction?
yes! you are right !! I need the date of a most recent transaction .... I have used the max function to get the end date in the date table so that should not be the issue
Cool, then can you please share the names of the columns in your transaction table
when I create a relationship between date table and survey table the visual gets blank if I delete the relationship it is giving me a total
columns in the transaction table
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!