Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |