Forum Discussion

BITomS's avatar
BITomS
Solution Supplier
2 years ago
Solved

Date Data Type as 'What If' Parameter

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 t...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.