Date Data Type as 'What If' Parameter

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.