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)

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.

...