Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I want to find out the opposite of EOMONTH() and trying to find the beginning date of 12 months ago

1 Answer

0 votes
by (22.5k points)
edited by

In DAX Use the following

= DATE(YEAR(Dates[Date])-1, MONTH(Dates[Date]), 1)

For more information on Power Bi, check the following Power Bi Tutorial

Also, do check out our YouTube video on Power BI visualization techniques:

Go for this in-depth job-oriented Power BI training online now!

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 4, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Jan 11, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Nov 21, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...