Forum Discussion

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago
Solved

Calculate Sum Month Year

WorkingTime_Jan = Calculate ( Sum (LN[ArbeitszeitInH]))   There is a column in the table "LN" with dates. I want to summarize only the operations which had taken place in January 2018. The date for...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    BachFel,

    Create a measure using DAX below. If you don't  get expected result, please share dummy data of your table.

    WorkingTime_Jan = CALCULATE(SUM(LN[ArbeitszeitInH]),FILTER(LN,YEAR(LN[DateKey])=2018 && MONTH(LN[DateKey])=1))



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

BachFel,

Create a measure using DAX below. If you don't  get expected result, please share dummy data of your table.

WorkingTime_Jan = CALCULATE(SUM(LN[ArbeitszeitInH]),FILTER(LN,YEAR(LN[DateKey])=2018 && MONTH(LN[DateKey])=1))



Regards,
Lydia