Dynamically change card visual based on date selection

Question

Hey all,&nbsp;I have a card visual which displays the 'Days Left in Month'. This is a measure that just takes the date difference between today and EOMONTH.&nbsp;&nbsp;My end-user wants to be able to see what numbers for next month look like. When they filter for Next Month in the 'Date Selection' filter, the 'Days left in Month' visual still only show the date diff between today and end of current month.&nbsp;How can I set it up so that this visual will dynamically change? If they're looking at current month, it will take the date diff between today and end of month. And if they're looking at next month, it will just calculate total days in the month? I think a SWITCH() function will be used here, but not sure how to implement this.&nbsp;&nbsp;&nbsp;

rsbin · Accepted Answer

murphm6 ,
You are close.&nbsp;&nbsp; Please try this:
DaysLeftinMonth = SWITCH(
                      TRUE(),
                      [MaxSelectedDate] = EOMONTH( TODAY(), 0 ), DATEDIFF( TODAY(), (EOMONTH( TODAY(), 0 )), DAY ),
                      DAY(EOMONTH(TODAY(), 1) ))

Where
MaxSelectedDate = MAX(DIM_Date[Date] )
My quick test shows it works, but may need tweaking depending on how many Months in the future the user selects.
Hope you can get this to work for you.
Regards,

Forum Discussion

Dynamically change card visual based on date selection

2 Replies

Related content

Dynamic Status Change for events based on selected date range

Dynamic change of Default Slicer selection

Dynamic images based on selections

Change in category selection changes selected subcategory in slicers

Dynamic Filtering based on date selection