Forum Discussion

ContabilidadBI's avatar
ContabilidadBI
Helper III
9 years ago
Solved

Problem with DATESMTD

Hello guys,   I am new to power BI and I have been struggling to make a simple month to date sales card for a few hours. Here is the formula:   MTD de Total = CALCULATE(SUM(Albaranes[Total]);DATE...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Your english is great!

     

    *if* you calendar stopped at the end of May... this would work fine.

     

    Ignoring that, you can add a calc column on your calendar table:

    IsCurrentMonth = IF (MONTH(TODAY()) = MONTH(MyCalendar[Date]), TRUE(), FALSE())

     

    Then set a filter on the card visual to IsCurrentMonth = TRUE  ?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ooohh!

 

MTD doesn't respect the current date at all.  It's relative to the current filter context.  If you go create a table w/ every day on it... you will see your measure working... growing the value each day, until end of month... when it resets to 1st day of month again.

 

You would need to do some sort of  FILTER(ALL(Calendar), Calendar[Date] > TODAY() - DAY(TODAY()) + 1)

or probably easier to add a calc column to your calendar table IsCurrentMonth and use that to filter.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Oh this makes so much sense now
Cheers!