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

Actually... In case we are lucky...   I assume your calendar table is going "into the future" -- it doesn't stop at THIS month.   Could that be changed?  In which case... your current MTD would magically work?

ContabilidadBI's avatar
ContabilidadBI
Helper III
9 years ago

Thanks Scottsen, don't really understand your last reply. My Calendar table goes until 12/31/2017 so until the end of the year.

 

English is not my first language.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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  ?

  • ContabilidadBI's avatar
    ContabilidadBI
    Helper III
    9 years ago

    Thanks man, I learned a lot today!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    This worked for me, i just don't know why..
    DATESQTD() and DATESTYD(,) worked fine...... why not month??