Forum Discussion

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
4 years ago

Dynamic date filter not working

Hi Guys,   I have attached a link to a pbix which includes a month slicer and a matrix, I would like to select one month from the slicer and have the matrix display only 3 months of data up to and ...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi JimJim ,

 

Is it possible to explain the logic of the formula you created, it seems that the filter function is causing the problem. Looking forward to your reply.


Best Regards,
Henry

 

 

  • JimJim's avatar
    JimJim
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hi v-henryk-mstf , thank you.

     

    I am trying to allow a user to select a month from a slicer and show them data for x months up to and including the selected month. I am using a fiscal calendar

     

    The demo I followed is https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/, however, Alberto uses whole months in his calculation and I'm not able to do this as I'm using a fiscal calendar. Therefore my logic is trying to work out the first date and last date and and show quotes that fall between both dates.