Forum Discussion
Super UserLatest Version to pick before Start Date
Hi Gurus
I have below scenario where the main data is
Now if I have date range in report say 5/15 - 5/30 then it should data which falls in the range or latest data before start date as below :
another example
I can get data for all TM_IDs with its latest Date in one query and in another query I can have all data . but when I combine or union and try to apply Date Filter it filters data before start date naturally.
Any trick or workarounds are appreciated here.
3 Replies
- Ashish_Mathur
Hi,
Create a Calendar table and a relationship (Many to One and Single) from the Date column of the Fact table to the date column of the Calendar table. Create a slicer from the Calendar table and select t he between layout. Select your date range. In a table/matrix visual, drag the 3 columns from the Fact table.
Hope this helps.
srlabheThanks it worked what changes we have to do in ToShow measure to achieve below so that it just gives latest data as of that date
