Forum Discussion

carlos1945's avatar
carlos1945
Copper Contributor
May 14, 2020

TOTAL of the month (just)

Hi Community, I need to have the all of the spending corresponding for the current month. I have tried TOTALMTD and DATESMTD but in the last case it added until last row, even if it's in the differe...
excel
power bi
Abiola1's avatar
Abiola1
MVP
May 14, 2020
The best thing to do is to use PivotTable for your dataset
  • carlos1945's avatar
    carlos1945
    Copper Contributor
    May 15, 2020
    Yes i know some ways to reach the goal, using IF measures. But i thought there might be some function DAX more direct to get the goal.

    But It's ok. Thanks for your help