Forum Discussion
learning_dax
Helper II
Helper IIFiltering based on a selected Date slicer value
Hi all, Been noodling on this for some time now. I have a dashboard that gives monthly snapshot of sales, # of interviews, etc. The entire page revolves around a Month & Year slicer, so that I ca...
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.
jgeddes
Super User
Super UserSorry 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.