Forum Discussion

pmhoang94's avatar
pmhoang94
Helper I
9 years ago

Issue slicer date range

Hi all,

I have a slicer date (option: before) from table DimTime(Time). (start date: 1/2/2017 and end date: 26/6/2017)

I create meassure

MaxDate = CALCULATE(MAX(DimTime[Time]), ALLSELECTED(DimTime))

My issue is:

 - If I choose date is 26/6/2017, maxdate is 26/6/2017. It is true.

- If I choose date is 27/6/2017, maxdate is 26/6/2017. It is false.

I want to maxdate display correct date choosed. Or only choose date range start date: 1/2/2017 and end date: 26/6/2017 (not allow choose 27/6/2017)

Can anyone help me?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Do you have data in the table DimTime that actually has 27/6/2017 data in it?

     

    If none, then the measure is working properly.

    • pmhoang94's avatar
      pmhoang94
      Helper I
      9 years ago

      I do not have data in 27/6/2017.

      When I choose 27/6/2017, i want my measure result is 27/6/2017. Or do not allow choose 27/6/2017

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Sorry, but I don't think that's how a measure works.

         

        You either put in dummy data for 27/6 or resize the date slicer viz under Format > Text Size and then put in a "MaxDate" text box under or next to it.