Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need Solution without slicer values show current year

need this eroor soliution

  • Anonymous , In case of some other year is selected, use all('Date') in place of 'Date'  in filter

     

    YTD Today =
    var _min = eomonth(today(),-1*month(today()))+1
    var _max = today()
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

     

    LYTD Yesterday =
    var _today = TODAY()-1
    var _max = date(year(_today)-1, month(_today), day(_today))
    var _min = eomonth(_max,-1*month(_max))+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

    This year Today =
    var _min = eomonth(today(),-1*month(today()))+1
    var _max = eomonth(_min,11)
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

    Last year Today =
    var _max = eomonth(today(),-1*month(today()))
    var _min = eomonth(_max,-12)+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

     

    https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

1 Reply

  • Anonymous , In case of some other year is selected, use all('Date') in place of 'Date'  in filter

     

    YTD Today =
    var _min = eomonth(today(),-1*month(today()))+1
    var _max = today()
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

     

    LYTD Yesterday =
    var _today = TODAY()-1
    var _max = date(year(_today)-1, month(_today), day(_today))
    var _min = eomonth(_max,-1*month(_max))+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

    This year Today =
    var _min = eomonth(today(),-1*month(today()))+1
    var _max = eomonth(_min,11)
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

    Last year Today =
    var _max = eomonth(today(),-1*month(today()))
    var _min = eomonth(_max,-12)+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

     

    https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304