Forum Discussion
Solved
Help Filtering a Card/ Chart Based on Dynamic Dates
I need to filter a card and chart visual by a date range that is being selected in a slicer. For example, the user will pick 3/15 in the As Of Slicer and a year in the Year Slicer. I need to calcul...
jslade , if you select a date and want to display a trend of more than the selected date/dates, Then you need an independent date table
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
jslade , if you select a date and want to display a trend of more than the selected date/dates, Then you need an independent date table
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Thank you that helped me get it working. I didn't have to create the second date table but the video of the measures helped me to get it to work. My measure worked as:
Actualized Fill = var MaxDate = SELECTEDVALUE(FactDOR[As Of Date])
var MinDate = IF(DAY(MaxDate) < 20, DATE(YEAR(MaxDate), MONTH(MaxDate), 1), DATE(YEAR(MaxDate), MONTH(MaxDate), 15))
RETURN
CALCULATE([Incremental Fill],FILTER('FactDOR', FactDOR[Date] >= MinDate && FactDOR[Date] <= MaxDate))