Need urgent help Dax

[Aamir_khan]

Hi All,

I have years data from 2019 Dec to Jan 2021 I have used below query but I am not getting 2021 in the report

I need help on the following dax Month Date = If(day([Date])<=10, eomonth([Date],-1), eomonth([Date],0))

from 2019 to 2020 is correct but I am not getting 2021

[v-xulin-mstf]

Hi @Aamir_khan,

I can’t reproduce the error in my environment, the dax worked in my environment.
Here is the output:

Could you provide your sample data?

Best Regards,

Link

[ryan_mayu]

@Aamir_khan 

I didn't see date colum in your screenshot. Do you have data that is bigger than 2021/1/10?

[VijayP]

@Aamir_khan 

Some how I am getting when i tried with a sample Data. Just check whether you have dates in 2021?