Forum Discussion
nirvana_moksh
Impactful Individual
Impactful IndividualShow <= Value Date based on the date selected
Hello All, I have a date filter slicer set which is populated from one table and based on the selection made in the filter I want the measure to look up the start dates column of another table an...
nirvana_mokshImpactful Individual
Impactful IndividualAshish_Mathur - Sadly it did not work. I think in short what I want the measure to do is based on the selected date it looks up the closest (<=) Start Date for the selected group id. In my head, it so simple, but trying to do that via DAX is turning out to be painful this time around
Here is the PBIX file with sample data wherein I tried using it - https://1drv.ms/f/s!Au9CSosUldp9hE-ZyXFm9ppRHpF1
Ashish_Mathur
Super User
Super User