Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

dynamic calendar

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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