Forum Discussion
m_wex
Helper I
Helper ISelection Date Slicer
Hi Everyone, Created a date slicer based on a date table linked to my invoiced sales table. The invoiced sales table only contains data through March 2021 but the slicer shows all quarters for 20...
m_wexHelper I
Helper IHi Amitchandak,
Thank you. Should I amend the relationship? From single cross filter direction to both?
With the Dax solutions. Is it possible to only show the last invoiced sales dare from the sales table for the date slicer? What I need ultiamtely is to map the last invoice date in the sales fact table to the slicer. That end date could be any date depending on how the fact table is updated. Right now, it is updated on a monthly basis but I am trying to get the report as close to real time as possible.
M_Wex