Forum Discussion
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...
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 ?
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 ?
This worked for me, i just don't know why..
DATESQTD() and DATESTYD(,) worked fine...... why not month??