locked
calculate filter by month RRS feed

  • Question

  • Hello. How can I filter by month with calculate in powerpivot. Count just january for example. 
    Monday, August 22, 2016 5:13 PM

Answers

  • The filter context is usually picked up automatically based on the rows and columns. If you want to hard code a DAX expression to only include values for the month of January, you could do something like CALCULATE( SUM(MyTable[MyColumn]), MONTH(DateTable[DateColumn]) = 1)

    Tuesday, August 23, 2016 12:34 AM