Forum Discussion
Measure to filter correct date from another table
Hello All, I am running into an issue creating this measure which is driving me nuts. For this example, I have two tables. One has a List of Dates which is used as a filter as below: which...
nirvana_moksh try adding following measure
Recent Date =
VAR __baseDate = SELECTEDVALUE('List Date'[Date])
RETURN
CALCULATE( MAX(Table[Start Date]), Table[Start Date] <= __baseDate )
parry2k - Sadly that did not work, I had tried something similar as well and I think what it ends up doing is checking MAX os the start dates instead of seeing it in relation to the filter selected. Below is what it returned when I used the measure suggested:
nirvana_moksh doesn't make sense, share the pbix file thru one drive/google drive, remove any sensitive inforamtion
parry2k - Extracted the small data set from these two tables for your reference, there are actually 10 tables and lot of relationships, but I think this covers it basically for these two. Thanks!!!
https://1drv.ms/f/s!Au9CSosUldp9hE-ZyXFm9ppRHpF1