Forum Discussion
Dynamic Text Box based on relative date filter
Hello again, Im looking to make a dynamic text box indicating what the dates are for the current filter. For example, I have a last calendar week relative data filter. I need the text box to say:...
HI Anonymous,
According to your description, it sounds like your table date range not completed. If this is a case, I think you need to do some calculation to expand them to full week records.
Measure = VAR _min = MINX ( VALUES ( 'Table'[Date] ), [Date] ) VAR _max = MAXX ( VALUES ( 'Table'[Date] ), [Date] ) VAR _minCal = _min - WEEKDAY ( _min, 2 ) + 1 VAR _maxCal = _max + ( 7 - WEEKDAY ( _max, 2 ) ) RETURN _minCal & "-" & _maxCalRegards,
Xiaoxin Sheng
You are selecting Min/max from Calendar table as Suggested by Greg_Deckler or from your data table?
Anonymous - Right, as amitchandak says, you should be using the same table and column for your min/max as in your slicer. If you are using the Date column from your fact table, try creating a separate Calendar/Date table using CALENDARAUTO or CALENDAR and then creating a relationship on your Date columns.