Forum Discussion

Witold's avatar
Witold
Frequent Visitor
4 years ago
Solved

IF Funcion, in DATEBETWEEN with PARAMETR

Hi, I'm in the middle of making a forecast with the leverage tool. For this I took whole the calendar but want to Parameter Function works only for a specific date and be disable for rest of it. 

So I decide that the easiest way would be to put lmits on the Parametr dimension (GENERATESERIES). 

 

My code looks like 

Parameter Sessions = IF(DATESBETWEEN('Date Table'[Date],2022/10/01,2023/12/31),GENERATESERIES(0, 20, 0.001),GENERATESERIES(0,0,0,0). 
 
To disable "what if" for different dates than my chose period I use GENERATESERIES FOR 0.
It does not work, can you show me some different way to reach it ?
 
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Witold , if you are looking slicer to control your table that will not happen, A calculated table can not use slicer value.

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Witold , if you are looking slicer to control your table that will not happen, A calculated table can not use slicer value.

     

    • Witold's avatar
      Witold
      Frequent Visitor
      4 years ago

      Thanks! This is a answer that im looking for. 

      But amitchandak, if I like to make an ajustment slicer with "what if" parameter I cant make a dynamic change for it at all? For example a simple formula that says "if parametr get 10 points, devide by 2" ?