cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aamir_khan
Advocate V
Advocate V

Need urgent help Dax

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 2021from 2019 to 2020 is correct but I am not getting 2021

3 REPLIES 3
v-xulin-mstf
Community Support
Community Support

Hi @Aamir_khan,

 

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

v-xulin-mstf_1-1611129666745.png

 

Could you provide your sample data?

 

Best Regards,

Link

ryan_mayu
Super User II
Super User II

@Aamir_khan 

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

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




VijayP
Super User I
Super User I

@Aamir_khan 

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




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors