Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

month and Year

Hi i'm trying to calculate Pro Bono Hours of the current month and year.   I originally had the below formula, but that required me to update every month.   MTD Billable = CALCULATE([Pro Bonos],...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Your parens are wrong:

    MTD Pro Bono = 
  CALCULATE(
    [Pro Bono],
    FILTER(
      'Work Date',
      'Work Date'[Calendar Year]=YEAR(TODAY()) && 
      'Work Date'[Calendar Month]=MONTH(TODAY())
    )
  )
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Try:

    MTD Pro Bono = 
  CALCULATE(
    [Pro Bono],
    FILTER(
      'Work Date',
      'Work Date'[Calendar Year]=YEAR(TODAY()) && 
      'Work Date'[Calendar Month]=FORMAT(TODAY(),"mmmm")
    )
  )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 

 

Hi Greg, 

 

Thank you I've updated the measure but recieved the below error

 

 Is it because the 'Work Date'[Calendar Month] is listed as August and not 8

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Try:

MTD Pro Bono = 
  CALCULATE(
    [Pro Bono],
    FILTER(
      'Work Date',
      'Work Date'[Calendar Year]=YEAR(TODAY()) && 
      'Work Date'[Calendar Month]=FORMAT(TODAY(),"mmmm")
    )
  )