Forum Discussion

Dom87326's avatar
Dom87326
Icon for Helper II rankHelper II
4 years ago
Solved

MAX date

Hello PBI Community,    I have the following table with both fields in text type and filter slicer with year from dimDate table.   dimDate 1:* %DATE_KEY   I am trying to build a condition...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Dom87326 , Try like

     

    new =
    var _max = max(Table%DATE_KEY])
    return
    format(date(left(_max,4), mid(_max,5,2), right(_max,2)), "YYYY MM DD")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Dom87326 , Try like

 

new =
var _max = max(Table%DATE_KEY])
return
format(date(left(_max,4), mid(_max,5,2), right(_max,2)), "YYYY MM DD")