Forum Discussion

sayang194's avatar
sayang194
Frequent Visitor
4 years ago

Pass multiple date parameters to Web URL when loading data

I want to load data from a report that has a Effective date parameter. I have another table (Effdate) with a list of all effective dates (start date of every month from 01/01/2021. How can I pass the...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

sayang194 , You should code that in measure

 

if(isfiltered(Table[effective Date]), [Meausre], calculate([Measure], filter(Table, Table[effective Date] in values(Table2[Effdate])) )