Date Data Type as 'What If' Parameter

[BITomS]

Hi there all,

I was wondering if anyone had any experience with creating a Report Parameter (i.e. from the modelling tab within Report view, NOT a parameter within Power Query) with a date data type? And if so, how they went about doing this?

I've had a request from a business user where they'd like to be able to change a specific date to scenario model how this different start date can affect cost over a time period. The date would feed into a calculation based on market rates from this selected date.

Currently, parameters only seem to accept numeric values, so this may need to be an idea request, but thought i'd ask before creating this, especially if any of you bright souls had found a workaround.

[Anonymous · Accepted solution]

Hi @BITomS ,

Using the what if parameter is also essentially switching the contents of the field via slicer. I made simple samples as you described and you can check the results below:

Total = SUM('Table'[Value]) 
% = var _select = MIN('Table 2'[Date])
var _period = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Date]>=_select))
RETURN DIVIDE(_period,[Total])

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@BITomS , Usually we can achieve this using a disconnected Date table. Depending on what measure is needed

You can switch date filter of date, or use the filter on multiple dates.