Forum Discussion
Consecutive Week End Dates
Hello Team, Trying to implement the solution for the Consecutive Week End date, Below is the detail description of the same, Let's say if i choose any date from my date slicer then it should ...
You can use a measure similar to the below:
ConsecutiveWeekEndDate = FIRSTDATE(TOPN(1,SELECTCOLUMNS(FILTER(DIM_DATE,DIM_DATE[Week End Date]>=MAX(DIM_DATE[Week End Date])),"Next Week End Date",DIM_DATE[Week End Date]),[Week End Date],DESC))
The above measure needs some editing for table/column names as I don't have the model. If this doesn't work, you can share a pbix file with the model and sample data so we can further assist.