Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Two Separate Date Selection

Hi, I am willing to implement two drop downs for date selction: Start Date, End Date. My page will have two types of vizes: 1. Viz only impacted by the End Date 2. Viz impacted by both Star...
Need Help
Show and Tell
Tips and Tricks
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    You need two date tables. one for "From" and another for "To".

     

    Measure:

    V1 = IF(SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer2'[Date]),1)
    V2 = IF(SELECTEDVALUE('Fact table'[Date])>=MIN('Slicer1'[Date]) && SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer2'[Date]),1)
     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

I suggest you use two date table. One for slicer and another for your fact table. The slicer date table ( i mean which table's date column is used for slicer) is just used to input parameters for measure.

 

For example, the viz only contains date column in it.

 

V1 = IF(SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer'[Date]),1)

V2 = IF(SELECTEDVALUE('Fact table'[Date])>=MIN('Slicer'[Date]) && SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer'[Date]),1)
 
If i misunderstood you, please let me know.
 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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
4 years ago

Thanks for your effort v-chenwuz-msft 

What I am looking for is to have two separate date selectors like this:



However, I could not create a measure which will give me all the dates in between the dates selected on From and To boxes above ...

 





  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    You need two date tables. one for "From" and another for "To".

     

    Measure:

    V1 = IF(SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer2'[Date]),1)
    V2 = IF(SELECTEDVALUE('Fact table'[Date])>=MIN('Slicer1'[Date]) && SELECTEDVALUE('Fact table'[Date])<=MAX('Slicer2'[Date]),1)
     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    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
      4 years ago

      This is brilliant, thanks !