dynamic calendar

[Anonymous]

Dear all, 

I have a dataset with data getting updated everyday. I have set up the relative date filter to show data till the last calendar months. But I would like to set up a dynamic calendar where if the filter is off people can see entire data upto date and if the filter is on then they can see only upto last completed calendar months. Is there anyhting like a dynamic filter set up in Power BI?

Thanks 

Regards

Malini

[Anonymous]

Hey Thanks for your solution but it doesnot work. It says the syntax var_max cannot be detected

[amitchandak]

@Anonymous , Create like

calendar =

var _max =eomonth( today() ,1)

return  calendar(date(2020,1,1), _Max)

or

calendar =

var _max =eomonth(Max(Table[Date])  ,1)

return  calendar(date(2020,1,1), _Max)