Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to modify expression to display Jan till May 2021 ?

Hi All

 

Below expression return Jan till Dec :-

YTD DATE =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = minx(allselected('Date'), 'Date'[Date])
return format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES BY BRAND_C"
 
May i know how to modify the above expression , so that it will return Jan till May ?

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    admin11 , something like this

     

    YTD DATE =
    var _max = today()
    var _min = minx(allselected('Date'), 'Date'[Date])
    return format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES BY BRAND_C"

2 Replies

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

    admin11 , something like this

     

    YTD DATE =
    var _max = today()
    var _min = minx(allselected('Date'), 'Date'[Date])
    return format(_min, "MMM-YYYY") & " to " & format(_max, "MMM-YYYY") & " SALES BY BRAND_C"