Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamically filtering a KPI visual by current financial year?

Hi,    I am new to PowerBi. I am creating a CPD dashboard and I want to dynamically filter a KPI visualization by current financial year. This should be only for one visualisation. Also, I have a f...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like


    Measure =
    var _max = var _max = maxx(allselected('Date'),'Date'[Date]) // OR// eomonth(Today(),0)
    Var _maxFY = maxx(filter(allselected('Date'),'Date'[Date] = _max), 'Date'[FY])
    return
    calculate(sum(Table[value]), filter(date, Date[FY] =_maxFY))

     

     

    You can also trywih FY end date

     

    YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"03/31"))

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

Anonymous , Try like


Measure =
var _max = var _max = maxx(allselected('Date'),'Date'[Date]) // OR// eomonth(Today(),0)
Var _maxFY = maxx(filter(allselected('Date'),'Date'[Date] = _max), 'Date'[FY])
return
calculate(sum(Table[value]), filter(date, Date[FY] =_maxFY))

 

 

You can also trywih FY end date

 

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"03/31"))