Forum Discussion
Calculate Filter not working
Hi All
I have a 5 day rolling set of numbers determined by a selected date (SelectedDate BW) and a lag date (BW LAGDATE) which is 5 working days before the selected date.
I then have this measure so that I can display 5 days between the lag date and the selected date. But it is only giving me for the selected date.
So essentially I have this:
When I need it to be looking like this:
Note: For the second screenshot I used lagdate= selected date-10, but that was not working well to accommodate weekends and public holidays.
1 Reply
sthandiwe , if you select a single date and want to display 5 days. you need and independent table
refer this
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
