Forum Discussion
Problem with DATESMTD
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 ?
Hi,
I was trying again and If a put a month slicer in the same page of the report and filter for may, then yes, the card shows the sales amount for may until today. But what I want is a card of the running sales of THIS MONTH, which right now is May but it should change to 0 in the first day of June.
Thats it Scootsen! uff at least I know now what was going on.
So, what would be the measure formula that will always calculate the sum of sales for the month we are in? that formula you put would be a filter parameter of the CALCULATE fuction I put in my first message? I can do the calculated column for this month, but I prefer if I can do it with only a measure.
I have a card that shows the sales of the month in a dashboard, but when next month starts, I have to filter the card again, upload it to Power BI service and delete the other one, so what I am trying to achieve is a card that will automatically update when the month finish and the next one starts
How would be the formula for the calculated column THIS MONTH btw?
Thank you so much!!!
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?
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.