February 2021 and calculations

[Cyrilbrd]

Good day, 

I have noticed that February 2021 was displaying some unusual values.
After reading the blog "DAX Time intelligence and the 29th of February – #PowerBI" I discovered that I might be using the wrong approach to get the information I need.

Table required:

As seen above I need to show per day the cumulative sales last month, the cumulative sales this month and the ratio.
The measures are as follows:

MTD_LM = CALCULATE([Actual],

DATEADD(filter(DATESMTD(Date_table[Date]),Date_table[Date]<=today()),-1,MONTH))

MTD = TOTALMTD([Actual],Date_table[Date])

MTD_var = divide([MTD],[MTD_LM],"")

I noticed that the table was however returing incorrect values for Feb 29th ,30th and 31st.
It should be blank and yet as describe by Erik Svensen, my measures are returning values. 

As seen above 29th 30th and 31st are showing values.

Anyone could guide me, I am sure that the measures are wrong and might need tweeking.
Thanks.

[v-xulin-mstf · Accepted solution]

Hi @Cyrilbrd,

Try measure as:

Measure = 
CALCULATE(
    SUM('Table'[Column2]),
    PREVIOUSMONTH('Table'[Column1]))

Here is the output:

Best Regards,

Link

[amitchandak]

@Cyrilbrd , Have you tried like

last MTD Sales = CALCULATE([Actual],DATESMTD(dateadd('Date'[Date],-1,MONTH)))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Cyrilbrd]

sorry this is still displaying data for 29, 30 and 31.

data comes from server via mysql so no sample available here.

would you need anything else?