Forum Discussion

DataUser's avatar
DataUser
Icon for Helper I rankHelper I
5 years ago

Scenario building using dates & What-if Parameters

Hullo  - I know I need to use some combo of time/date slicers and a what-if parameter for this, but I'm struggling to put them together correctly.    Objective is for a user to be able to pick a st...
Need Help
v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, DataUser 

According to your description, I can understand clearly what you want to get, you can try my steps:

  1. Create a calendar table based on your data range like this:

 

Date = CALENDAR(DATE(2021,1,1),DATE(2021,1,10))

 

  1. Create a What-if parameter and add a slicer to the page like this:

 

  1. Create a measure in the ‘Table’ like this:

 

What-if Amount =

IF(

    MAX('Table'[Date]) in ALLSELECTED('Date'),

    MAX('Table'[Amount])+[Parameter Value],

MAX('Table'[Amount]))

 

  1. Then create a data range slicer and a table chart and place them like this:

 

And you can get what you want.

You can download my test pbix file here

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

DataUser's avatar
DataUser
Icon for Helper I rankHelper I
5 years ago

When I try to switch it over to a calculated column, it's still not functioning correctly. My formula looks like this but all that it returns is the maximum value in the AmountSharepointList[AMOUNT] column, so I assume it's reading the condition as "False" for some reason.

 

WhatifColumn = IF(

MAX(AmountSharepointList[Date])in ALLSELECTED('Date'),
MAX(AmountSharepointList[AMOUNT])+[What-If Capacity Value],
MAX(AmountSharepointList[AMOUNT]))