Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Lastday = CALCULATE(DISTINCTCOUNT(survey_reports[responseId]),LASTDATE(date1[Date]))
Hi @Nischal
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
survey id
question
answer
store id
response id
date
motion
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |