Forum Discussion
Helper IIFiltering based on a selected Date slicer value
Sorry I misread your initial post. If you are looking for current future sales confined to the current fiscal year you could add a isCurrentFiscalYear column that returns Yes or No if a date is in the current fiscal year to your date table and then use that column as a limiting filter in your future sales calculation.
Super UserI am not sure there is enough information here to give a concrete answer however in my experience I have run into issues where I had a calculated max date on my date table that was limiting my measures simply because it had no more dates past a date. In this case I am wondering if your date table has dates past May 31, 2023?
learning_daxYes my calendar table has dates past May 31, 2023. I simply only want "future sales" based on a given slicer Month/Year value but only for that current fiscal year. I don't want future sales for the entirety of Order Dates but only for this fiscal year, which is why I want > the current Month/Year selected but limited to the end of the fiscal year which is May 31, 2023