Forum Discussion

PXJ99's avatar
PXJ99
Frequent Visitor
3 years ago
Solved

Annual Budget Meaure

Dear all,   I have a query please. I need to calculate annual budget and it lies in a month. Example: Month YTD Budget Jul 500 Aug 700 Sep 900 Oct 1500 Nov 1600 Dec 170...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    PXJ99 

    is this what you want

    Measure = sumx(FILTER('Table','Table'[Month YTD]="Jun"),'Table'[Budget])

  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    is this what you want

    Measure = sumx(FILTER(all(Forecast),Forecast[Month ]="Jun"),'Forecast'[Forecast])

    when you change the month filter, the output for measure is always 2000

PXJ99's avatar
PXJ99
Frequent Visitor
3 years ago

Thanks very much

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

you are welcome