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],FILTER('Work Date','Work Date'[Calendar Year]="2021" && 'Work Date'[Calendar Month]="August"))

 

So I wrote the below formula however, it isn't  working. any assistance would be helpful.

 
MTD Pro Bono = CALCULATE([Pro Bono],FILTER('Work Date','Work Date'[Calendar Year]=YEAR(TODAY() && 'Work Date'[Calendar Month]=MONTH(TODAY())))) 
 
Thanks
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")
    )
  )

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    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())
    )
  )
    • 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")
    )
  )