Forum Discussion
Find Latest date
Hi All, The data that I have has all the surverys that were done to all the stores. I want to consider only the latest visit to a store for that month. If the store was not visited on that month...
Hi Bhavya,
Since you have a Date table, it could be a simple measure like below. Please download the demo from the attachment.
Measure = CALCULATE ( MAX ( FACT_DETAILS_KPIS[Visit Date] ), FILTER ( ALL ( DIM_DATE ), DIM_DATE[Date] <= MAX ( DIM_DATE[Date] ) ) )
Best Regards,
Dale
Hi Bhavya,
Since you have a Date table, it could be a simple measure like below. Please download the demo from the attachment.
Measure = CALCULATE ( MAX ( FACT_DETAILS_KPIS[Visit Date] ), FILTER ( ALL ( DIM_DATE ), DIM_DATE[Date] <= MAX ( DIM_DATE[Date] ) ) )
Best Regards,
Dale
This is one step closer to what I needed but I can't replicate the results. It's only showing the latest record I have.
I'm trying to display the latest ACTIVE amounts per location per month (but latest record not summed up), I think finding the latest dates per month is close to that goal.
Here is my file: