Back

Explore Courses Blog Tutorials Interview Questions

What is the opposite of EOMONTH() in Power BI (DAX)

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
Power BI DAX: ALLSELECTED with exception of one column
asked Apr 5, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI (DAX): Calculating MoM Variance of a Measure Field
asked Feb 22, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
What is DAX expression in Power BI?
asked Nov 4, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
DAX to follow the hyperlink - Power BI
asked Jan 11, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI first IF-Statement then the DAX-Formula
asked Nov 21, 2020 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...