Forum Discussion

powerbityro's avatar
powerbityro
Helper II
7 years ago

SINGLE SELECT last date

Hi All :robotindifferent:   I have ich Slicer with   2019/1 2018/4 2018/3   and choose SINGLE SELECT with 2019/1. But when I get new Data with 2019/2 the choosen Button is still 2019/1. Can I...
Need Help
  • powerbityro's avatar
    powerbityro
    Helper II
    7 years ago

    It is possible to use

     

    if Date.IsInCurrentMonth( [Date] )
    then "Current Month"
    else [Month]

     

    with Output current date 2019/1 instead of the text "Current Month"?

    • powerbityro's avatar
      powerbityro
      Helper II
      7 years ago

      I have no Date. Only Year and Quarter and Year/Quarter.

      • powerbityro's avatar
        powerbityro
        Helper II
        7 years ago

        I work in Direct Query Mode... so both solutions... MAX in Column and

         

        if Date.IsInCurrentMonth( [Date] )
        then "Current Month"
        else [Month]

         

        is not accepted. Is it than not possibe in DQ Mode or do you have some further ideas? :robotmad: