Forum Discussion

ravitejaballa's avatar
ravitejaballa
Helper III
6 years ago

Slicer With single selection

Hi, I have a data like below, where "Months Since Started" is months difference with current date => (TodayMonth - startDateMonth) Now i want to have slicer on report which filters 1. Contract ex...
Need Help
ravitejaballa's avatar
ravitejaballa
Helper III
6 years ago

dax Ashish_Mathur amitchandak 

Here is my sample data.

 

DeviceContract Start DateMonths Since Started
A17-Dec-193
B21-Sep-1818
C15-Oct-195
D14-Jan-202
E16-Sep-196

 

IndexContract expirying
1with in 6 months
2with in 3 months
3with in 1 month
 

 

So Slicer should filter table as below.

1. Contract expirying "with in 6 months" => Shows Devices = A, C, D, E

2. Contract expirying "with in 3 months" => Shows Devices = A, D

3. Contract expirying "with in 1 month" => Shows Devices = C, E

dax's avatar
dax
Community Support
6 years ago

Hi ravitejaballa , 

Yes, as Ashish_Mathur  mentioned , the"within 1 month" option should return blank(the date which within a month of today is 202/2/29-2020/3/31, no records within this range, it should return blank). Or you also could inform me your logic of  "within 1 month", then we will help you more correctly.

Best Regards,
Zoe Zhi

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

  • ravitejaballa's avatar
    ravitejaballa
    Helper III
    6 years ago

    Ashish_Mathur dax 

    To simplify further.

    Same slicer but data should filter as shown.

     

    ExpiryIn1Month =
    IF(mtagData[contractDateDiff.months] == 6, TRUE())

     

    ExpiryIn3Months =
    IF(AND(mtagData[contractDateDiff.months] >= 1, mtagData[contractDateDiff.months] <= 3), TRUE())

     

    ExpiryIn6Months =
    IF(AND(mtagData[contractDateDiff.months] >= 1, mtagData[contractDateDiff.months] <= 6), TRUE())